Regular Expression for the Following Request:

Yes it is just a few names out of thousands, so yeah it's specific. This name also appears in multiple columns. I have tried using this formula you gave me but it appears to move around the names and keep the formula. For example, Lou-Mary Ann became Lou Ann-Mary.

shaheer

I tried using your formula but the name did not change for some reason. Would it be because I am using a multi field formula and then formula tool in sequence?

The multi field formula tool is the one that is rearranging the names that are in lastname, firstname format. Next, I just want to clean up the names like Lou-Mary Ann.

binu_acs

@shaheer try the formula, it is specific only for the above pattern

REGEX_Replace([Name], '(.*),(.*)\-(.*)', '$3 $1')

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703