Regex for Matching First Alphanumeric Character skipping (The |An? )
- by TheLizardKing
I have a list of artists, albums and tracks that I want to sort using the first letter of their respective name. The issue arrives when I want to ignore "The ", "A ", "An " and other various non-alphanumeric characters (Talking to you "Weird Al" Yankovic and [dialog]). Django has a nice start '^(An?|The) +' but I want to ignore those and a few others of my choice.
I am doing this in Django, using a MySQL db with utf8_bin collation.