Parsing CSV data incorrectly

an example please

Good evening Datagrunt

Originally Posted by Datagrunt

I have a script I am running that outputs CSV files. If I open it in notepad++, everything is parsed correctly. Values with commas are protected within the quotes that are added in the script. However, Excel does not recognize the quotes

Are you wanting to create the .csv files without quotes? What code are you using at the moment? Are you using Save As ... .csv, or are you using the Write# / Print# commands. If the former, you will need to use the latter, if the latter, you will need to use Print# command, as Write# will put each discrete set of data within quotes.

HTH

DominicB

I'm working in Java and I resolved this through a hack:

This is an Adobe script for extracting XMP information from files. The script originally saved it as a CSV file but it wouldn't parse correctly in Excel.

I modified the script so that it wouldn't add quotes to the either the column headers or the values. I also changed the delimiter to a semi-colon (and you can choose any character you like, it doesn't have to be a semi-colon). When I open the file in Excel, I simply to a text to column using the semi-colon as the delimiter. Everything is then parsed correctly.

Please Login or Register  to view this content.