Removing "NUL" characters in CSV file

[mauuuuu5]

Hi everyone I am writing a CSV file, but when I see the file in notepad++ I see some weird characters like this one:

I searched in stack overflow and found here, that I should remove this regular expression \x00

hence I used the String Manipulator node

…but is not working

Thank you

[mlauber71]

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

String Emoji and Character Class Filter – takbb

RegEx - remove line breaks and special characters from column name – mlauber71

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

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.,!@#$%&*()=+~-]","…

Cell splitter delimited wrong on Chinese punctuation marks

@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:

[mauuuuu5]

Thank you, I am going to try those workflows