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
