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:
解決済! 解決策の投稿を見る。
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,