Remove/Replace special characters in column

[Phil1007]

Hi There,

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

But it doesn’t work

Thats the column with the characters I want to remove:

Can anybody help me?

[armingrudd]

Hi @Phil1007 and welcome to the KNIME community forum,

Use this expression in the String Manipulation node:

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

[Phil1007]

Thank you very much @armingrudd

My final regex is:

[armingrudd]

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)

[Phil1007]

Perfekt, thanks. Marked as solution!