Hello! I am trying to remove a special/invisible character, I tried using the String Manipulation but it remains in there. Here I share you some pictures [image] As you can see, the date seems to be ok. However, if I copy paste that text in Word, I get this: [image] I would really appreciate if you have any recommendation on how to delete those specific characters! Since I need to String to date that column

@NathanDrake one option could be to remove all characters from a string that are not explicitly allowed. You might adapt this example. Maybe you also provide us with a sample file. [image] Tree Ensemble Learner does not recognize newlines in column names (include/exclude filter does) KNIME Analytics Platform @tims you could use a regex function and a “Insert Column Header” node to clear your variable names. The logic is you remove everything that is not explicitly permitted. In this case a blank is OK. You might edit that to your needs. regexReplace($Column Name$,"[^a-zA-Z0-9 ]","") [image]

Remove special/invisible characters

KNIME Analytics Platform

mlauber71 June 21, 2022, 5:46pm 3

@NathanDrake one option could be to remove all characters from a string that are not explicitly allowed. You might adapt this example. Maybe you also provide us with a sample file.

5 Likes