I'm familiar with how case statements work, I'm looking for some help on how to select the proper case statement based solely on the artists first letter. This is being used for a MySQL database being imported via csv.
So it would be something like:
if (%artist% == 'A')
then SQL foo = SQL A directory
if (%artist% == 'B')
then SQL foo = SQL B directory
if (%artist% == 'Z')
then SQL foo = SQL Z directory
if (%artist% == '0-9')
then SQL foo = SQL NUMBER directory
This will be done in the export option that I have to build. I have full control of the csv aspect, I'm just trying to figure out how to do case selection or do I have to do a long winded if/else/elseif/elseif type thing
Can someone point me to a previous example or give me a short hand script of how this would look in the export routine.