[RESOLVED] Parsing Question

[sford]

This is NOT a VB question per se... it is more of an Excel csv parsing question... I didn't know which would be the best forum to pose the question and I am using VB so that is why I chose this forum...

Hypothetical situation...

Making a CSV file...
Line one has three columns with this content

first          A,B"C       third

If I make the string
first,A,B"C,third

It is interpreted as
first         A              B"C        Third

If I make the string
first,"A,B"C",third

It is interpreted as
first        A,BC"         third

How do I get it to ignore the imbedded commas and quotes in the second field?????

[DataMiser]

You must surround anything with embedded commas with Quotes and I think you need to double up on quotes to get them to come in though not sure on the latter

A,"B,C",D

Would be A B,C D

It is generally better to use tab delimited files

[sford]

Thanks DM... I decided to switch to Tab as the delimiter...