When wildcard renaming ", the" , I always add provisos:
1: If ", the" is part of the phrase ", the - " then simply delete;
that takes care of band names starting with "The".
2: If ", the" is at the end then replace the second occurence
of " - " with " - The "; that sorts out songs which start with the
word "The".
3: As with item 2 above, same with ", A " ; never ever
understood that logic of taking an a from the beginning and
tacking it onto the end of a title.