Parsing CSV data incorrectly

[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 and it wants to parse the data at every comma. Has anyone else had this problem?

Thank you,
Chris

[martindwilson]

an example please

[dominicb]

Good evening 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

[Datagrunt]

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.

for ( var i = 0; i < mdItems.length; i++ ) {
                    if ( i == 0 ) {
                        theRecord += ';' + mdItems[ i ].element.property + '';
                    } else {
                        theRecord += '; ' + mdItems[ i ].element.property + '';

and...

         if ( a == 0 ) {
                            theRecord += ';' + val + '';
                        } else {
                            theRecord += '; ' + val + '';
                        }