[BUG] Error on parsing line breaks within quoted fields

[zitrusblau]

Expected Behavior

Interpret and convert line breaks in quoted fields correctly.

Actual Behavior

Unable to convert/parse CSV correctly. Error thrown:

/app/node_modules/convert-csv-to-json/src/csvToJson.js:215 throw new Error('Row contains mismatched quotes!');

Steps to Reproduce the Problem

1. Create a CSV adding line breaks within a quoted field
2. use option .supportQuotedField(true)

Specifications

• Version: 2.0.0

[zephyrdark]

Hi everyone, i chanced upon this issue & I am interested to give it a shot. I have looked at how the code works. Please correct me if I'm wrong.

Currently the parser works by

1. Read input csv file and extract its content, separated by linebreak characters (CLRF), to string. - fs.readFileSync
2. Split the string by linebreak characters (CLFR) - csvToJson.split, and parse each individual line to see if they contain quotes (")
3. ...

When an input csv has a quoted field that contains linebreak characters (CLFR), that field would already be split into 2 lines at the end of step 1 due to how fs.readFileSync works. However, I believe that regardless of the number of linebreaks in a quoted field, all its values should still be contained within the same column.

Thus, I propose that we insert step 1a inbetween steps 1 and 2: Recombine the "line-broken" lines back into a single line, based on number of column headers. For example:

input csv:

firstName	lastName	email	gender	age	birth
Constantin	"Langsdon, Langsdon"	clangsdon0@hc360.com	Male	96	10.02.1965
Norah	Raison	nraison1@wired.com	"Female"" "	32	10.05.2000

end of step 1:

firstName,lastName,email,gender,age,birth
Constantin,"Langsdon,
Langsdon",clangsdon0@hc360.com,Male,96,10.02.1965
Norah,Raison,nraison1@wired.com,"Female"" ",32,10.05.2000

end of step 1a:

firstName,lastName,email,gender,age,birth
Constantin,"Langsdon,Langsdon",clangsdon0@hc360.com,Male,96,10.02.1965
Norah,Raison,nraison1@wired.com,"Female"" ",32,10.05.2000

... continue from steps 2 onwards

@iuccio What are your thoughts? If my idea is acceptable, I can work on it.