Flip First and Last Names in a Column

[veronikababiciute]

I have a column in the format of Last Name First Name, eg Smith John. I want it to change to John Smith. Help please! 

[atcodedog05 · Accepted solution]

Hi @veronikababiciute 

Here is how you can do it.

Formula:

REGEX_Replace([Field1], "(.+)\s(.+)", "\2 \1")

Workflow:

Hope this helps : )

[HomesickSurfer]

Hi @veronikababiciute 

Though not as clean as the Regex, here's my approach that allows for variations of Firstname and possible middlename

[veronikababiciute]

Worked, thank you so much! 

[atcodedog05]

Happy to help : ) @veronikababiciute 

Cheers and have a nice day!

[Meenssankar]

If I want include comma after reversing the string using regex_replace?

[atcodedog05]

Hi @Meenssankar 

The formula would be add comma between 2 and 1

REGEX_Replace([Field1], "(.+)\s(.+)", "$2 ,$1")

Hope this helps : )

[trevorwightman]

I have never taken the time to learn regex so I just stick with string manipulation to get what I want. I just rebuilt the name by finding the space and taking what is to the right, then adding a space and then taking what is the left. Cheers!