String Manipulator Issue with Regex Replace

Hello, I’m trying to use the String Manipulator node with Regex replace to check the values listed in the image below, When I apply the following function: (-\D+) according to online resources like regexr or others it should work, but when I apply it in this node, the value does not change for the first and third value.

image

Hi @sirabelk3,

You have to use two backslashes before “D”. One to escape “D” as a special character in regex and one for the expression itself to escape the next backslash.

For example, the expression below will remove “-SAT” and “-B” in your examples.
regexReplace($column$, "-\\D+", "")

:blush:

5 Likes

Great, many thanks for the help. Regards.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.