Hi everyone I am writing a CSV file, but when I see the file in notepad++ I see some weird characters like this one: [image] I searched in stack overflow and found here , that I should remove this regular expression \x00 hence I used the String Manipulator node [image] …but is not working Thank you

@mauuuuu5 you might want to take a look at these workflows / components if indeed the characters are present within KNIME. [image] String Emoji and Character Class Filter – takbb String Character Class and Emoji Filter Filter out emoji and other classes of characters from a string using a built in Regular Expression. This component can … [image] RegEx - remove line breaks and special characters from column name – mlauber71 RegEx - remove line breaks and special characters from column name Sometimes special characters can be really tricky if they closely resemble other ones. [image] Weird Character Appearing KNIME Analytics Platform @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] Cell splitter delimited wrong on Chinese punctuation marks KNIME Analytics Platform @Long I experimented with putting Unicode characters in flow variables and using that on UTF-16LE csv files which does work. The flow variable though can not be used in cell splitter. I put it up anyway:

Removing "NUL" characters in CSV file

KNIME Analytics Platform

mlauber71 March 10, 2023, 5:00pm 3

@mauuuuu5 you might want to take a look at these workflows / components if indeed the characters are present within KNIME.

Sometimes special characters can be really tricky if they closely resemble other ones.

4 Likes