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!