Hello, I have been recently faced with a very simple problem, which I unfortunately cannot solve:
I have a column “XYZ” including the following strings:
What I would need is to get rid of those brackets and save the result in a number format. How could I do that?
I tried Regex Split Node, but it didn’t work. Maybe i used the wrong Formula. I used this one: (.*)
Thank you in advance!
You can use a String Manipulation-Node with »removeChars($XYZ$, “()”)« and afterwards convert it to a number with a String To Number-Node.
although you are not splitting cell this is syntax you can use in
Regex Split node:
square bracket are not necessary in regex pattern if you know that parentheses are always present.
You can write:
don’t understand your comment
There was a problem with escape of escape regex.
I mean that when you write [\(] you are defining a set with a single char: (
If you know that the string start with ( and end with ), your regular expression can be \(([0-9]+)\) (without square brackets over round brackets)
I see now what you are thinking. You are right. Tnx!
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.