Bug-Report: File Reader multi-line quoted strings and row limit

KNIME Analytics Platform
1

See

https://tech.knime.org/forum/knime-users/file-reader-issue-with-csv-in-cell-line-breaks#comment-39618

The skip first n rows configuration does not take the "Quoted strings can extend over multiple lines" option into account. It just starts reading at the n th row in the text file and not the n th "actual data row". So the 2 options can not be used in combination. you get an unexpected result and most likley a "too few data elements" error (unless you also select the "short lines" option. In that case you get an unexpected output).

Solution:

Do row limiting on the actual data rows and not lines in the text file.

 

 

 

 

 

 

 

2

Hi,

The idea of this "skip first n lines" option is really to allow you to read files that "don't make sense" in the first lines. E.g. files with really weird headers. 

Can't you just skip one more line? Or read in the data starting with the first line and connect a row filter to filter out the first few data rows from the table?

 - Peter.