Regex - Fix names without removing space between names

Hi,

I'm trying to fix a field for names. Currently its displayed as: 635;#John Do and I need it formatted as 'John Do'. There are multiple names and they all appear to have a '#' right before the actual name.

When I used RegEx \W it removed all white space and make it 'JohnDo'.

What is another method I could use?

Thanks

Regex

Accepted answers

Kenda

Hey @BigDataGeek, this is what I used. See if it works for you, too.

REGEX_Replace([Field1], "(.*\#)(.*)", "$2")

All comments

Kenda

Hey @BigDataGeek, this is what I used. See if it works for you, too.

REGEX_Replace([Field1], "(.*\#)(.*)", "$2")

BigDataGeek

Hi, I'm having problems getting that to work, likely due to an understanding of how to insert it into my workflow.

I added a formula then entered that into the expression, but the output was exactly as the input.

BigDataGeek

This worked with the formula function. Thanks for your help!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235