On 7 May 2012, at 4:41pm, peter korinis <korinis at earthlink.net> wrote:
> My input file is a comma-delimited text file > When I run .import I get the following "Error: FILE line 1: expected 46 > columns of data but found 1" > It seems .import is not recognizing comma delimiter. <http://www.sqlite.org/sqlite.html> "The default separator is a pipe symbol ("|")." Simon. So, if I use gawk to change my comma separated file to | (pipe) delimiter . will it work? Do I have to use ".mode csv" as Jonas just advised? Thanks, peter _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users