CSV File Format
-
Hi everyone. I recently wrote a program which saves data into a CSV (comma separated value) file. I searched and was unable to find the exact specifications for the format. Since each data string is surrounded in quotes in the file itself, how do I handle quotes in the data string itself? Do I leave them, and only change the commas between quotes, which signify a break between strings? And if I change them, what do I change them to? One CSV file I downloaded had the quotes in the strings changed to %22's. Anybody know more or where I can find more info, so my CSV is compatible with other programs which may read it?:confused:
-
Hi everyone. I recently wrote a program which saves data into a CSV (comma separated value) file. I searched and was unable to find the exact specifications for the format. Since each data string is surrounded in quotes in the file itself, how do I handle quotes in the data string itself? Do I leave them, and only change the commas between quotes, which signify a break between strings? And if I change them, what do I change them to? One CSV file I downloaded had the quotes in the strings changed to %22's. Anybody know more or where I can find more info, so my CSV is compatible with other programs which may read it?:confused:
www.wotsit.org[^] HTH Cheers ;P "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
-
www.wotsit.org[^] HTH Cheers ;P "An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
Turns out one doubles up quotes within the data string. Thanks for the link! ;)