Turning "Firstname Lastname" Album Artists into "Lastname, Firstname" Album Artist Sort

[LyricsLover]

There are several solutions already available in this forum.
Please use the search function with words like
swap firstname lastname

And please be aware the many exceptions that exists beside group names, like artists with multiple parts in the name as "The Artist formerly known as Prince" or combinations like "Bob Marley & The Wailers".

BTW: Do you remember your own similar question here:

Add space to, swap Lastname,Firstname

Before I reinvent the wheel: Is there a known way to do something like the reverse, to change a field with, say, "John Coltrane" to "Coltrane, John" by swapping the words and placing a comma after the one moved to the first position? I do this a lot by hand (and realize that I would have to look at the contents before doing it to avoid messing up "Jethro Tull").

including the Howto answer:

Regular Expressions

Another one, that switches first and last names (for instance, Jacques Brel will become Brel, Jacques: Regular Expression:^(.+)\s(.+)$ Replace with: $2, $1