On 30 Apr 2010, at 8:23am, am65 wrote:
> I tested using a blank space between the commas, like this (", ,") instead of
> this (",,") and this way the value of the next column is not put in the null
> column. But then the column is a blank space instead of a null.
Try putting quotes around all the text values in the file
"Col A"," Col B"," Col C"
"textA","","textC"
This should give you a zero-length string for the middle value. But I do think
that the double comma should work too.
By the way, neither standard for CSV, without quotes or with quotes, ignore
spaces after the comments for formatting purposes. The line in your initial
post
Col A, Col B, Col C
will give a value of " Col B", not "Col B".
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
