Parsing "," inside " " Problem

[masdevid]

Hello, I have a problem when my clients include "," in address field. I use "," as delimiter. So, I couldn't insert a new row because "," inside the address field.
My CSV read file result like this:

0, Name, Address
1, Devid, Working Street Indonesia
2, Devid, "Not working Street, Indonesia"

But, only row 0 and 1 are working to be parsed in JSON.

[masdevid]

I know I can simply change my CSV delimiter as ";", but it would be nice if it can handle "," inside "text"

[bahaaldine]

I added support for this kind of use case.

Cheers

883075c

[rondog]

This seems to work for the content part, but not the JSON part. It returns an empty array. The reason being if ( currentline.length === columnCount ) fails because the column count is defined by content.separator causing it to split inside a quoted string.

It looks to work in your demo, but not on the directive I pulled down with bower

[rondog]

changing to var columnCount = lines[0].split(content.separator).length; to var columnCount = lines[0].split(new RegExp(content.separator+'(?![^"]*"(?:(?:[^"]*"){2})*[^"]*$)')).length; fixed it for me.

[bahaaldine]

Hi rondog, you can create pull request :)