On 9/20/08, Qianqian Fang <[EMAIL PROTECTED]> wrote:
> excellent! this works for me.
> thank you very much!
>
>
> Qianqian
>
>
> Kees Nuyt wrote:
> > You will have to transform the XML into an INSERT statement,
> > like this:
> >
> > INSERT INTO final (idx,enc,data) VALUES ('rec1','001','line1
> > line2
> > line3');
> >
>
>
Going back to your original question Qiangian... unfortunately, it
seems the CSV .import mechanism can't handly line breaks in records
(someone please correct me if I am wrong).
I created a table like so and added a record to it
sqlite> CREATE TABLE foo (a, b, c);
sqlite> INSERT INTO foo VALUES (1, '001', 'line1
...> line2
...> line3');
sqlite> SELECT * FROM foo;
1|001|line1
line2
line3
sqlite> .m csv
sqlite> .sep "|"
sqlite> .o foo.txt
sqlite> SELECT * FROM foo;
sqlite>
meanwhile, back in the shell
% less foo.txt
1|001|"line1
line2
line3"
%
back in sqlite3
sqlite> .import foo.txt foo
foo.txt line 2: expected 3 columns of data but found 1
sqlite>
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
