I have a CSV file with a field that includes both commas and double quotes. Magic Parser doesn't seem to be parsing the file correctly.
In my CSV file the fields that include commas are surrounded by double quotes. In a field that includes double quotes, the quotes have an extra set of double quotes around them.
The problem seems to occur when I have a comma and a double quote in the same field - e.g.
Favorite Movies: "Crash", "Gladiator", and "Titanic".
The CSV format puts double quotes in front of fields with commas, and an extra set of double quotes before and after quotes to differentiate them from end of text field delimiter. Here is what the CSV data looks like for this field:
"Favorite Movies: ""Crash"", ""Gladiator"", and ""Titanic""."
Let me know if that makes sense.