On 2013-02-21 13:15:16 +0100, Gert Van Assche wrote:
> Roger,
>
> thanks for the advice, but I cannot work like this. I don't have the
> possibility to rewrite the txt files I receive.
> If I use the SQLite Expert, I get an error on "double-quote character" or a
> "range error"...
>
> Any other suggestions?
I think is the "double-quote character" break the line,
I find in the table each row has mutilines all has a double-quote (")
in the first line and another in last line , except the last row
I think you can prehandle the txt file change the " to another string
like:
sed -i.bak 's/"/@@/g' test.txt
and then in sqlite:
.import test.txt Source
UPDATE Source SET Segments = replace(Segments, '@@', '"');
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
