uniVocity / univocity-parsers

uniVocity-parsers is a suite of extremely fast and reliable parsers for Java. It provides a consistent interface for handling different file formats, and a solid framework for the development of new parsers.
905 stars 249 forks source link

CsvParserSettings.setSkipEmptyLines(false) issue #475

Open Tarun275 opened 3 years ago

Tarun275 commented 3 years ago

Issue Description: Not able to read csv file contents when first record is empty with skip empty lines false configuration. (Considering file with no header.)

Issue cause: csvParserSettings.setSkipEmptyLines(false);

Issue reproduceable at:

while ((record = parser.parseNextRecord()) != null) {

}

File contents:

# This example was extracted from Wikipedia (en.wikipedia.org/wiki/Comma-separated_values) # # 2 double quotes ("") are used as the escape sequence for quoted fields, as per the RFC4180 standard #

Year,Make,Model,Description,Price 1997,Ford,E350,"ac, abs, moon",3000.00 1999,Chevy,"Venture ""Extended Edition""","",4900.00

# Look, a multi line value. And blank rows around it!

1996,Jeep,Grand Cherokee,"MUST SELL! air, moon roof, loaded",4799.00 1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00 ,,"Venture ""Extended Edition""","",4900.00