Not reading all Commas in "Column delimiter"

[mlauber71]

@Le18BR in line 6 there is a very messed up format. The whole line is enclosed in a quotation and then ZENDES, INC. (which has a comma in the name) again is enclosed in a double quote. Some cleanup might be necessary and if such things appear in a CSV file on a regular basis disaster is imminent. I will see if I can come up with a solution. Question ist would this be a pattern like quotes at the beginning and end or would there be all sorts of strange quotations.

Would it be possible to use a less common separator in the CSV file?

CSV Writer adds random rows while creating the file

@pranavgupta you could try to use R to write the CSV file and see if there is a different outcome. CSV files are not ideal when transferring data but I do understand why they are still being used. Sometimes I used even more excotic characters as separators like the “flattened turtle” ¤ ASCII 164. And you definitely should check for some hidden line breaks in the original data.