4] Transform Artist from "B, A" to "A B" or "B, A ©" to "A B ©"
ex: "Smith, John" to "John, Smith" or "Joel, Billy & Elton John" to "Billy Joel & Elton John"
Regular Expression Replace: "^([\w]+),\s([\w]+)" with: "$2 $1"
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.
This did not work for me and I wonder why. I tried it with "D'León, Oscar & The Orchestra" but I get no change.
If I do it with Lopez, Orlando "Cachaito" it does change it to "Orlando "Cachaito" Lopez.
I am looking for an action that will change B, A C & D E F to A B C & D E F.
Basically anything after the first word after the comma stays the same and the word after the comma becomes the first value and the comma is removed.
Ex: D'Leon, Oscar & His Orchestra to Oscar D'Leon & His Orchestra.
A variation that allows for a middle name, like Vaughn, Stevie Ray & Double Trouble to Stevie Ray Vaughn & Double Trouble. Were everything after the second word after the comma stays the same and the two words after the comma get moved to the front..
Another variation is being a able to do this in a string of words like if you have Himely, Eduardo / Suarez, Alejandro / Puisseauz, Carlos / Rico, Eduardo being able to switch each of those to A B from B, A. I assume the action would just have to delineate the " / " as a separator.
Any help would be greatly appreciated!