Taking what I've learned here and elsewhere, I've not got the following 5 actions to choose from when renaming Artists in this fashion; perhaps compiling them here may help others. (*Most of mine are set up as format field with the $regexp function but I tried to standardize them in describing them):
From "First Name(s) Last Name(s)" to "Last Name(s), First Name(s)" Format:
Transform Artist from "A B" to "B, A" or "A B C" to "C, A B"
ex: "John Smith" to "Smith, John" or "John Michael Smith" to "Smith, John Michael"
I find this works well with all two-word names no matter if you've added more stuff to the end and it is safe to run on all artist who DON'T have comma's in their name field too; except for those who have more than two words in their proper name.
5] Transform Artist from "B C, A" to "A B C" or "C, A B" to "A B C"
ex: "Smith Jones, John" to "John Smith Jones" or "Smith, John Michael" to "John Michael Smith"
This simply takes everything before the comma and puts it at the end, which works great for all names, no matter how many words in the first or last, but doesn't play nice with non-name suffixes you may have added (like "Joel, Billy and Elton John").
Adding or Removing Leading "The "
6] Restore Leading "The " to Artists' Names
7] Delete Leading "The " and "A " from Artists' Names
Thank you very much for providing a solution to change the names.
It works for my director case as well.
But - to be very honest - I do not know why.
I am looking for a manual for this magix regexp-function.
Is there anybody in the forum who has created such a manual?
I checked the help pages but I do not understand how this fromatstring works.
Fromatstring: $regexp(%artist%,(.)',' (.),$2 $1)
What does the string (.*) means?
What does the string $2 $1 means?
From a very high perspective I believe it is clear.
Look for the last letter in artist. Name this phrase as $1.
Continue to search in artist. Name that phrase in $2.
Replace $1 by $2 and add a comma.
Furthermore I saw in the forum the following expression: (.+?) (.+)
What does that means?
I would be very happy to get more information about the regexp-function.
was müßte ich schreiben, daß automatisch erkannt wird, daß wenn der Dirigentenname aus 3 Namensbestandteilen besteht z.B. Sir Charles Mackerras in Mackerras, Sir Charles umbenannt wird und wenn der Difigentenname nur aus 2 Namensbestandteilen wie z.B. Niklaus Harnoncourt besteht in Harnoncourt, Nikolaus umbenannt wird.
This is the English part of the forum, so please stay in English.
You see the (English) help pages in your local language, if you call the help from Mp3tag with F1 - so this might shed some more light on the topic.
The reason why your expression works is due to the "greadiness" of the expression: the first expression tries to grab as many hits as possible.
In general I am not a friend of swapping first and last name as this always causes havoc with names that have to stay that way: Pink Floyd, Rolling Stones, "Dave Dee, Dozy, Beaky, Mick & Tich", "Katrina & the Waves" and so on.
So, unless you want to keep a special advisory which name gets swapped and which one doesn't, I think it is easiest not to swap anything at all. My opinion.
Thank you so much for the hint with the F1 Button.
Now the things are clear.
So sorry for replying in German. However I tried to find a solution in the forum and than I was forwarded to the international page.
I fully agree to your remarks regarding the artist names when we talk about pop music. The same applies for the "The" in the artist's name. I like the original name.
However talking about classic music I want to have Mozart, Amadeus as a composer and Solti, Sir Georg as a conductor when I want to select some music from my streaming agent. But that's my personel optinion. Other people might have different opinions.
Thank you for your time you invested into my topic and help. It was always appreciated.