On Aug 30, 2006, at 11:42 AM, Phil M wrote:
What is the proper method of handling CVS export when there is a
TEXT/BLOB column with illegal characters like Chr(9), Chr(13) and
Chr(10)? Are you suppose to BASE64 encode the data, or are CVS
parser suppose to be smart enough to pick all data between the
quotes (assume all quotes are escaped)?
Since there's no official "standard" there are lots of things you
could do.
Access exports them as is, but few CSV parsers can handle that (mine
can because I needed it to)
Excel does this as well.
Since those are, for me, two of the most common sources that I get
CSV fils from I wrote a parser.
It works differently than the built in RB one though because I cannot
make it a subclass of any of the Database objects (RecordSet,
DatabaesField, etc)
Otherwise I'd make it work the exact same
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|