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