Removing Tabulators from all coloumns in a table

[domiterd]

Hey,

I need a little help. I have a table there are integer, date, string coloumns in it. Almost every column has one or more cells with just a tabulator. How can I change those tabulators in the table with empty cell or missing value?

I’ve tried String manipulation(multi column) but it doesnt work on date and integer coloumns.

[tqAkshay95]

Hello @domiterd ,

Can you provide a sample data ?

[domiterd]

So like in POSTA and DEJAV… the are tabulators and I need to change them to missing value(?), but when I run the String manipulation(multi column) node it sends back an error when I try to run it on an Integer type column. But I cant select just the String type columns because I need to make this felxible so it runs on differently structred tables aswell.

[mlauber71]

@domiterd you could try this approach. Per definitions dates and integers cannot have tabs.

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

[domiterd]

Ok I figuered it out I can string manipulate, after changing the column types.