The problem is that I have a bunch of bands and the only labeled last name, first name is the first two words, which are the band leader. Sometimes it will be "& his orchestra,"other examples are "y su estrellas" or "with his lonely boys" etc. So I just need the first 2 words changed from the last, first to first last and the rest should stay the same.
Also, if you could also let me know how to do it with individuals who have a middle name, 2 last names, or a nickname, for example:
Ray Vaughan, Stevie & Michael Jackson
Lopez, Israel "Cachao" & su ritmo caliente
William, Henry Frank & the Crazy Cajuns
I tried "(.), (.) (.)" replace with "$2 $1 $3" but it does not work.
If it did I could experiments with variants such as
"(.), (.) (.) (.*)" replace with "$2 $3 $1 $4" for William, Henry Frank & the Crazy Cajuns, but I need to figure out why it does not work. I really wish I could wrap my head around regular expressions but as much as I try it eludes me.
I would also like to do the reverse, to go from First Name Last & his orchestra or first name last name y su estrellas to Last name, first name & his orchestra or Last name, First name y su estrellas.
I am hope once you give a couple of examples I can figure out how to construct the variants.
Thanks again for your help!
(I am not sure why some of the text above shows in italics)