I am trying to read a .tsv (tab-separated value) file with File Reader node (KNIME v.4.3.3). The data is quite a big one.
While reading in I get the following error:
“Execute failed: For input string: “Down, Left” In line 6308 (Row6306) at column #10 (‘Event value’).”
The configurations I tried in File Reader node are:
Column delimiter: tab
Quoted strings can extend over multiple lines: check
Ignore extra delimiters at end of rows: check
Allow short lines: check
None of the above configurations has helped.
I wonder whether this has smth to do with the File Reader node bug or not.
The below is the screenshot of how the quick scan of the file looks like:
Hi @Odko . I suspect that the issue might be with the data. Clearly, the node is able to read the file, and is able to read the data if formatted properly.
Can you try to open the file from nodepad and check the data around Row 6306 - 6308? The most common issue with these files is that there could be some additional \r\n, which is breaking the expected structure of the file.
It looks like the comma “,” between “Down” and “Left” is causing the issue. Is there any way I could avoid this issue while reading in the data? Actually, these two values should be read in as a single-cell value.
You could check out this collection and see if one of these ideas does help. Most likely you will have to experiment with the settings in the (new) CSV reader about incomplete lines or you could try and employ the R package Readr which tends to solve most of my CSV problem (examples in the links):
Hi @mlauber71, thank you for your reply. I was thinking of reading the data using R. As R would take quite a long time to read big data, I wanted to go with KNIME.
I just tested the suggestion by @Mark_Ortmann above, and it did work.
I will also check the post you shared! Thank you again!