> however, if the fields ALSO included quotes, as the encoding for
> these is usually to double them up:
> 1,$34,"hello, out there!","he said ""whoa!""","shawn"
> 2,$12,"hi!","he, like, didn't care, you know?","tom"
> 3,$5,"yo!","I said ""yes?"", but he didn't respond","joe"
Ok so if I double them up then it won't cause problems in
general when reading the file? That's good to know.
> I hate to tell people 'back to formula' as much as I have been
> recently, but there are just so many problems when using CSV data.
> You're really better off switching to XML for the files you receive.
Yeah, for some projects that might be ok, but for others I can't
tell a customer to change their file format. I even suggested going
to TAB delimited as a standard for some projects to avoid the
hassles, but "the customer is always right."
Thanks again for your time!
[C]
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
