CANNOT Import comma delimted, quote qualifed text file into Excel.
 

I can NOT import a simple comma delimited file below in to Excel, althought I
used " as text qualifier, and COMMA as delimiter. Excel (version 2003)
persistenly parse it as having 3 fields rather than having only 2 fields.

"Income - $10,000 - $19,999", "Income - $20,000 - $29,999"

Could you please enlighten me? Thanks!

CANNOT Import comma delimted, quote qualifed text file into Excel.
 

all the commas are throwing it off, if you check comma and space, it will
work for that example, but there always has to be a space after the comma for
it to work

"Feiming Chen" wrote:

I can NOT import a simple comma delimited file below in to Excel, althought I
used " as text qualifier, and COMMA as delimiter. Excel (version 2003)
persistenly parse it as having 3 fields rather than having only 2 fields.

"Income - $10,000 - $19,999", "Income - $20,000 - $29,999"

Could you please enlighten me? Thanks!

CANNOT Import comma delimted, quote qualifed text file into Ex
 

I have the same problem. It is comma quote delimited text containing three
fields where the middle field can contain commas within the quotes.

"OR", "OR - Measurement warning, re-analyze.", "true"
This should be three fields, not four. If I tell it comma and space are the
delimiters it seems to work but that makes very little sense

"dlw" wrote:

all the commas are throwing it off, if you check comma and space, it will
work for that example, but there always has to be a space after the comma for
it to work

"Feiming Chen" wrote:

I can NOT import a simple comma delimited file below in to Excel, althought I
used " as text qualifier, and COMMA as delimiter. Excel (version 2003)
persistenly parse it as having 3 fields rather than having only 2 fields.

"Income - $10,000 - $19,999", "Income - $20,000 - $29,999"

Could you please enlighten me? Thanks!