Remove/Replace special characters in column

Hi There,

how I can remove special characters in cells in one column? I tried the String Manipulation node with the expression:

20191220_Dialog%20-%200_38%20-%20String%20Manipulation

But it doesn’t work :frowning:

Thats the column with the characters I want to remove:

20191220_Appended%20table%20-%200_38%20-%20String%20Manipulation

Can anybody help me?

Hi @Phil1007 and welcome to the KNIME community forum,

Use this expression in the String Manipulation node:

regexReplace($position$, "&.*?;\\s*", "")

:blush:

4 Likes

Thank you very much @armingrudd

My final regex is:

20191220_Dialog%20-%200_41%20-%20String%20Manipulation

I did not know you wanted to remove the string completely.

I think this expression is better (sets missing value if matches):

regexReplace($position$, "&.*?;", null)

:blush:

3 Likes

Perfekt, thanks. Marked as solution! :+1:

1 Like

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