Regex for remove the first character that matches with $

KNIME Analytics Platform
#1

Hello, I have this string:

“$ something”

I just would like to the get a new result as below:

“something”

Of course I need to build a regex that removes the special character and the next space or tab only in the case of having the special character as first or within the string maybe.

Any suggestions?
Thanks in advance.

~g

#2

I have found the solution with the string manipulation node.
I have used the replace() function as showned below:

replace($my_column$, "$ ", “”)

Probably there are better ways of doing it, feel free to suggest something.

~g

1 Like
#3

Your solution is what I would have suggested. In many simpler cases, the String Manipulation node works just fine, and lets you avoid the potential complexity of RegEx.

Glad it’s working for you!