Read CSV with a new line char in one of the fields

I have a CSV file to load. A text data is wrapped in a double quote. However, some columns have newline character in a filed that is wrapped in double-quotes. The CSV Reader throws errors when it gets to that record.
There aren’t many options in the node to tell that column value can have wrapped text.
Does anyone have any idea how to read this file with the KNIME?

Data looks something like below.

"004",0,"Fix it",0

Hi @praveen_kk and welcome to the KNIME forum,

Please use the File Reader node, the click on “Advanced” button then in the “Quote support” tab check the “Quoted strings can extend over multiple lines” option.



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.