REGEX_Replace replace first , but not second

[marksyoung73]

Hi,

I'm new to REGEX and try to get my head around it.

In this example "Hard Rock Cafe International (USA), Inc.,1111-L"

How to I replace the , within a text but not a comma before the number starts?

thanks

[atcodedog05 · Accepted solution]

Hi @marksyoung73 

You can try Regex formula like below.

REGEX_Replace([Field1], ",([^\d])", "$1")

Remove all commas which is not followed by number. Comma (,) followed by Non number ([^\d]) is replaced with non number (i,e comma removed).

Workflow:

Hope this helps : )

[marksyoung73]

This is great. Just wish I could understand the layout a little more.

Any idea the best place to learn this stuff?

Thanks very much

[atcodedog05]

Hi @marksyoung73 

These resources might help you.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689

https://regexr.com/

Hope this helps : )