Suggestion: File / CSV-Reader: All to string (/int/dec/etc)

[mlauber71]

@Jrole maybe you try to use python to force the import of all columns as strings

Transcoding text in a set of files

@JM64 one thing you could do is employ Python and ChatGPT to create a small Python code to do what you want and put this into a KNIME workflow to handle the rest of your tasks. [image] The code would look something like this: import knime.scripting.io as knio import numpy as np import pandas as pd # Step 1: Import the file v_import_file = knio.flow_variables["File path"] df = pd.read_csv(v_import_file, sep='\t', dtype=str, header=None) # Step 2 & 3: Scan each column and replace strings for…