Reformat Artist tag for use in Album Artist tag

I would like to convert the artist tag from first name second name etc. last name to Last name, first name second name etc and place that into the Album Artist tag

Thanks

See the FAQs to see how to copy the contents from one field to another:

see e.g. this thread on the problem when swapping name parts:

I was able to copy the artist to album artist tag so that was OK. As for the second reference, it lead me to a lot of comments as to how stupid it was to do this. Not much use.
My need is to;
1.list individual artists as last name first, then the rest.
2. Bands will go unchanged except I strip the "THE " at the beginning.
3. For titles with multiple artists I only want to reverse the first listed artist leaving the remainder the same.
4. Final for artists with listings such as "Bob Moore & His Orchestra" or "Cathy Jean & The Roommates" I again only want to reverse the first name leaving the rest unchanged.

To that end after some searching I did find a post suggesting "Format string: $regexp(%ARTIST%,'([^;]+)(\s[^;]+)','$2, $1')" or "$trimLeft($regexp(%ARTIST%,'([^;]+)(\s[^;]+)','$2, $1'))". They do work for 1, individual artists. but not for 2, 3 and 4.

I have not yet figured out exactly how or why this code works but will look into that. Once I figure that out maybe I can come up with a solution.
Thanks

You may have overread that there is a link to


So technically, it is more or less clear what to do.

I still don't see the use of doing it, esp. as you found so many exceptions yourself.

may be something that one could cope with. But what about
Bell, Book & Candle
Siouxie & The Banshees
Dave Dee, Dozy, Beaky, Mick & Titch
The phantastic Alex Harvey Band
An example: "Oliver Onions" is a band name, not an artist's name - how would that be transformed? Like an individual because it looks like forename/lastname or like a band because you "know" it is a band?

Would "Uriah Heep" really be found easier under "Heep, Uriah", "Led Zeppelin" under "Zeppelin, Led"? "AC/DC" becomes "DC, AC/"?
I seriously have my qualms about that.
And as this apparently will only be applicable for the field ALBUMARTIST - how would you treat compilations - and find the artists in those?
And if you always have to remember whether it actually is a band or an individual and then have to navigate to that part of the alphabet instead of just using the search of the player or the filter where type in the name that you can read on the record label this naming scheme will not facilitate the search but lead to confusion.
Also, you would always have to modify the fields according to those rules - an additional step.
I do not think that any of the web sources will actually prepare fields for this kind of transition.
So I still think that, even though it is technically possible and MP3tag will do that in a jiffy, in respect to ease the handling of the collection it is a step backwards.

1 Like

I have a large library of music on my computer. The folder structure is drive:/Music/"A" thru "Z"/Artist/mp3 files. I will use the reformatted albumartist tag to build the folders.
Bob Moore & His Orchestra will be Moore, Bob & His Orchestra.
Bell, Book & Candle will stay Bell, Book & Candle.
Dave Dee, Dozy, Beaky, Mick & Titch will be Dee, Dave, Dozy, Beaky, Mick & Titch.
The phantastic Alex Harvey Band will be Harvey, Alex Band
Group names will basically remain the same, minus the leading The.
Group names like Gary Puckett & The Union Gap will be Puckett, Gary & The Union Gap.

To be frank, I was not asking for opinions on this, rather how to achieve it without spending hours and hours doing it manually. This setup works for me and allows me to find certain track more easily.

That is fine with me.
So please use the search function in this forum, the FAQs and HowTos as they feature loads of examples to swap words around.

Just a note:
My mistake: it is not the "Phantastic Alex Harvey Band", it is "The Sensational Alex Harvey Band"
(https://www.discogs.com/artist/426655-The-Sensational-Alex-Harvey-Band)
So "Sensational" would still be part of the band name... but apparently that name is currently not part of your collection, so no worries.