>From the docs: .separator STRING Change separator used by output mode and .import replace string with a comma, without quotes, then do your import. It should work.
David ________________________________ From: peter korinis <kori...@earthlink.net> To: sqlite-users@sqlite.org Sent: Monday, May 7, 2012 1:34 PM Subject: Re: [sqlite] is SQLite the right tool to analyze a 44GB file 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
