-
June 4th, 2009, 03:59 PM
#1
[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?????
-
June 4th, 2009, 04:33 PM
#2
Re: Parsing Question
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
-
June 4th, 2009, 05:36 PM
#3
Re: Parsing Question
Thanks DM... I decided to switch to Tab as the delimiter...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|