You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
My source CSV has values that contain commas. Every value has double quotes around it. How would I change this code to skip the commas that are inside of double quotes?
Code example: ID,Full Name,Address "85DD-019F","Alice","123 Park Ave, Topeka, KS, 66618"
I've tried setting the delimiter to '/,(?=(?:(?:[^"]*"){2})*[^"]*$)/' (from this link) but then the array is the entirety of the row, then a bunch of undefined to fill out the rest of the values.
The text was updated successfully, but these errors were encountered:
My source CSV has values that contain commas. Every value has double quotes around it. How would I change this code to skip the commas that are inside of double quotes?
Code example:
ID,Full Name,Address
"85DD-019F","Alice","123 Park Ave, Topeka, KS, 66618"
I've tried setting the delimiter to
'/,(?=(?:(?:[^"]*"){2})*[^"]*$)/'
(from this link) but then the array is the entirety of the row, then a bunch of undefined to fill out the rest of the values.The text was updated successfully, but these errors were encountered: