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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users