Weird Character Appearing

@badger101 a very strange case indeed. It you want to spot such things best copy them into an advanced editor like notepad ++ or visual studio code or something.

You might have to escape the unicode string in the RegEx syntax with KNIME.

regexReplace($$CURRENTCOLUMN$$, "[\\u200E]" , "")

Another approach can be to eliminate all strange characters and only leave the ones you explicitly allow (there was a debate about this before):

regexReplace($$CURRENTCOLUMN$$, "[^\\w\\d\\s.,!@#$%&*()=+~-]","" )

image

3 Likes