> Sure. I think the issue is that the file uses double quotation marks > rather than single ones. But, in that case, how do I mark an embedded > apostrophe?
No, the problem is that sqlite3 command line utility doesn't parse quotes in csv files. It gets line, splits it using comma as delimiter, disregarding any quotes and then inserts resulting strings into database. So you'll have to use something else for importing your database, maybe write your own importer. Pavel On Tue, Sep 22, 2009 at 5:21 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > On Tue, 22 Sep 2009, Pavel Ivanov wrote: > >> Could you show us this line 1? > > Pavel, > > Sure. I think the issue is that the file uses double quotation marks > rather than single ones. But, in that case, how do I mark an embedded > apostrophe? > > Line 1: > > "117172","Engineered Structures, Inc.","Brockway Center","10875 SW Herman > Rd","Tualatin","97062-8033","Washington","NWR","45.3834","-122.7882","1542","Nonresidential > Construct, Nec","Gen12c(Agent)","Stormwater; NPDES Construction More Than 1 > Acre Disturbed Ground, Issued By Agent","Minor","STM","Legal > Contact","Engineered Structures, Inc.","Gary","Ross","15940 SW 72nd > Ave","Portland","OR","97224-7936","503-968-6639" > > In both emacs and joe this displays as a single line. > > Rich > _______________________________________________ > 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
