How to flip last name, first name middle name

Question

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 Answer

Example solution and workflow attached!

kelsey_kincaid · Accepted Answer

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 Answer

@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 Answer

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