Remove special characters from the text

[bruno29a]

Hi @DmitryIvanov76 , I see you tried doing so using Unicode, but it did not work.

Have you tried using Hex instead? Hex never fails.

You can take a look at this thread where I explained and demonstrated how to do this with Hex:

Remove hidden characters

Hello, I have hidden characters in the data set I got and some special characters. I was able to remove the carriage returns with the string replacer node but I was not able to remove other hidden characters like the one after the string Pa.m3.mol-1 in my attached example. Please let me know if there is way to remove my hidden character and/or how to remove hidden characters at all. Thank you for your help. Claude. Example_with_hidden_characters.xlsx (8.5 KB)

Also, if you could share some sample data, that would be useful