Aug-11-2022, 06:23 PM
(This post was last modified: Aug-11-2022, 08:56 PM by deanhystad.)
Your file is not CSV because it does not consistently use the same character as a delimiter. Your file sometimes uses commas as a delimiter, but other times commas are just part of a string. You can include the delimiter in a string, but the string has to be quoted.
Another problem with your file is is doesn't have a tabular format. Sometimes a line is a new row, other times it is a continuation of the previous row. I think this can also be fixed by quoting the string.
My guess is your file is a botched attempt at making a CSV format file. It is easy to botch writing a CSV file. Really easy.
Another problem with your file is is doesn't have a tabular format. Sometimes a line is a new row, other times it is a continuation of the previous row. I think this can also be fixed by quoting the string.
My guess is your file is a botched attempt at making a CSV format file. It is easy to botch writing a CSV file. Really easy.