[RESOLVED] Parsing Question
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
Code:
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?????