Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Biz Talk NonXML > CSV file with v...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 929 of 978
Post > Topic >>

CSV file with values enclosed in quotes

by Mbobde@[EMAIL PROTECTED] May 10, 2007 at 05:56 AM

Hi All,
My flat file has comma seperated values but enclosed in quotes. The
problem I have it some of the values are description, which may have a
comma in between also. Here is a quick example of my file

"Maxima","CA","Nissan,Infiniti","Burbank,LA"
"Accord","CA","Honda,Acura","LA"
"Escort","WA","Ford","XYZ"

I have to treat values inside quotes are single values, but if I use the
comma as seperator, I dont get the correct result!

Has anyone hit this problem? and how can I resolve this?

Thanks in advance,
Milan
---
Posted via DotNetSlackers.com
 




 2 Posts in Topic:
CSV file with values enclosed in quotes
Mbobde@[EMAIL PROTECTED]   2007-05-10 05:56:14 
Re: CSV file with values enclosed in quotes
"Eric Stott" &l  2007-05-10 12:34:35 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 22:00:57 CST 2008.