Remove special/invisible characters

[NathanDrake]

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

As you can see, the date seems to be ok. However, if I copy paste that text in Word, I get this:

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

[duristef]

hi @NathanDrake
could you please upload an example file with just 5-10 dates?

[mlauber71]

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

Tree Ensemble Learner does not recognize newlines in column names (include/exclude filter does)

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

[NathanDrake]

Thanks @mlauber71 , I just applied that and it worked!