Reverse a String in a row

[Shekharreddy125]

Hello,

I have a data like below.

1.John David

2.Mock Refel

3.David Hats 

I want the out put in reverse string order like below

1.David John

2.Rafel Mock

....

...

I tried Text to columns and then combine but it looks lengthy.

Thanks in advance. 

[ConnorK · Accepted solution]

Hi Shekharreddy125,

One thing that you could try is breaking the names apart with a text to columns tool, and then combining the two columns in the correct order with a formula tool.

Here is an example.

[BenMoss · Accepted solution]

I would go with a regex function in a formula tool...

Regex_replace([field],"(\w+) (\w+)","$2 $1")

So take the first two parts and swap them round.

Ben

[ConnorK]

Apologies, I did not see your end note about the text to columns. You could also try parsing these items out with Regex in a formula tool, and then combining them back together within the same tool. However, I think the text to columns is a more simple approach.

[TravisR]

@BenMoss got the regex solution I couldn't figure out - but here's a non-regex formula:

Left([Field], STRCSPN([Field],'.')+1) + GetWord([Field], 1) + ' ' + GetWord(Right([Field], Length([Field]) - STRCSPN([Field],'.')-1), 0)

[Shekharreddy125]

It's working. Thank you so much @BenMoss

[Shekharreddy125]

Thank you for your quick response.

[nclassen]

Thanks Ben, I found this helpful as well!