Stop CSV Reader from column type auto detection

[mlauber71]

You additionally could use R’s readr to force all columns to string

Force R’s readr to import all columns of a CSV file as strings – mlauber71

Another possibility would be to read the data with the “Fixed Width File Reader” including the column names forcing all columns to be read as strings (you would have to set a width large enough to cover your data), split the cells by the delimiter.

Later you could reuse the first line and insert the column headers again. I think something like this has been discussed before:

CSV Reader long IDs

Never give up! Here is why: Actually, the CSV Reader node and also the File Reader node (if uncheck “ignore spaces and tabs”) preserve tabs but we cannot see them!! Just try the Cell Splitter with \t as delimiter and you will be surprised! Here is an example workflow in which I have used both nodes to read a CSV file similar to your case and split it to have all fields as strings: csv_tab.knwf (24.0 KB) Pure KNIME, like it?