First, thanks for this great software.
I have searched the various topics but cannot find an answer for this...
I want to move all the word THE at the beginning of all ARTIST fields to become (The) at the end of the field.
I can use the tool to change the case OK, but how do you move the word to the end of the ARTIST name?
So becomes <STONE ROSES (The)>.
If you also want to treat other leading articles the same way, use a regular expression similar to this one. Add or remove articles as you like, separating them with a vertical bar (pipe) character:
I'd be very careful about doing it like this. You wouldn't want to run this on any names don't start with 'the'. The action that I listed in the first reply won't alter any artist name that doesn't start with 'the'. It also has the flexibility to work with other articles by using the second regex shown in the reply.