Using Regex Replace to get different parts of a string

Question

Hi,

I'm trying to use the REGEX_Replace formula to extract a specific section of a string if a condition is met. I'm using the formula below which I saw in a different forum but for some reason is not working: REGEX_Replace([Plants Changed], "(\d+),(\d+)","$2")

Source:

Desired Output vs Current Output:

Workflow:

messi007 · Accepted Answer

Hello @andreahq ,

You have to change the \d to \w.

if [Field2]=2
then
REGEX_Replace([Field1], "(\w+),(\w+)", "$1")
else REGEX_Replace([Field1], "(\w+),(\w+)", "$2")
endif

Below the a simple test I have done

Hope that Helps 🙂

Regards,