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.
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+", "")
Great, many thanks for the help. Regards.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.