"My statements tested for accuracy, nice!" What, you thought I was gonna take a programmers word on it??? ;)))))
Like I said, I never knew there was a formal way to handle the CSV character in the data field, this is far more a problem of the rules/protocol never being stated completely rather than an implementation issue. Then of course there is the folks that make up their own rules too, eg, one could just as easily made the rule following the Unix "\" to delimit a special character in a data field as well. On Friday, July 18, 2014 5:02 PM, RSmith <[email protected]> wrote: > > > >On 2014/07/18 21:32, Jonathan Leslie wrote: >> Ryan, >> >> You are quite right, it is not a perfect solution. Thank you for your >> detailed explanation your's is a much more complete >> solution. I never knew about the quotes syntax being formal. that is very >> good to know. Sure enough, it works just as you described >> >> 1ºfield 1ºfield 2ºthis is a comment fieldºnumber 4ºlast field //.. etc. > >My statements tested for accuracy, nice! > >It is a great pleasure to post the detail, and thank you for the kind words, >but please note that it is not "my" solution, I simply >explained the CSV standard (partly) which in itself offers a real solution to >storing and working with csv data if the standard is >followed to the letter - something I try to always promote. All credit >belonging to the very clever folks who designed it - and the >only reason I have any amount of knowledge in this regard is due to very many >hopelessly broken designs of my own (and sometimes >others) that I had to figure out and fix over the years. > >If this helps anyone else save some time/pain it makes my past frustrations a >bit more vindicated, or at the very least, a bit less >useless, so thank you for that. :) > > > > >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
