On Mon, May 07, 2012 at 01:34:13PM -0400, peter korinis wrote: > So, if I use gawk to change my comma separated file to | (pipe) delimiter . > will it work?
If you use gawk, you can easily change your comma separated file to the series of correct SQL INSERT statements (besides ensuring validity of input data such as right number of fields in each row etc.) and not rely on the sqlite shell csv-parsing capabilities. Valentin Davydov. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
