I am undertaking a major re-tagging exercise and wish to standardise Artist entries in the format 'Last name, First Name'. At present a huge number of entries are in the format 'First name, Last Name' and I want to change all of these so that. for example, 'John Coltrane' becomes 'Coltrane, John'.
Is there a way I can set up an action to automate this?
Many Thanks, DetlevD. Unfortunately at present the Action leaves me with a leading space at the beginning of the new name, which of course means that my control point now puts it at the beginning of the alphabetical sort. I have experimented but can't work out how to amend the format to ensure that there is no leading space in the new name.