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.

"001",0,"Training",0
"002",0,"Knime",0
"003",0,"Knime
Analytics
Platform
",0
"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.

:blush:

3 Likes