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)>.
Many thanks