How to flip last name, first name middle name

[ramosjaqueline12]

Hi, I am new to alteryx. Is there a formula I can use to flip last name and first name? In Excel I was using the following formula [=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))].

My data has a column for full name, where the format is "Castoral, Darren Andre" or "Lopez, Anna M" and I would like to have it flipped to be "Darren Andre Castoral" and "Anna M Lopez". Thanks!

[BrandonB · Accepted solution]

Example solution and workflow attached!

 

[kelsey_kincaid · Accepted solution]

Hi @ramosjaqueline12 ,

I would suggest using the 'Text To Columns' tool to split the name where there's a comma, then a formula tool to concatenate them back together int he order you're looking for. Screenshot below.

[NickSm · Accepted solution]

@ramosjaqueline12 

As with most things in Alteryx, lots of ways to do it.  Here's a one-tool example using regular expression attached.

[BrandonB · Accepted solution]

Also, if you are more familiar with Excel functions, you might find that the substring function is closer to what you are used to. 

 

[ramosjaqueline12]

Thanks so much!

Both suggestions work and even though I am more familiar with Excel it seems like the text to columns solution is way simpler.

[ramosjaqueline12]

Thank you Nick! I was trying to figure out the RegEx formula but I am still trying to learn about all the options available in Alteryx. This example helps me a lot as well.

[melaniaserviss]

This is so awesome, thank you for posting. I was playing with RegEx the past 2 days but nothing worked right.

[crshep2021]

Exactly the solution I was looking for! Thanks for posting. Does anyone know how to do this with multiple names in one field? Each of the names are separated by a semi-colon ;  i.e. Doe, John; Last Name, First Name;