found a good tool: http://findandreplace.codeplex.com/documentation problem solved... I think.
thanks all for your help. 2013/2/21 Gert Van Assche <[email protected]> > If I remove the double quotes, the problem is solved indeed. > I'm working on windows. Do you know if there is an alternative to the SED > command or tool? > > Or is there a way I can force sqlite3 to ignore these double quotes? > > thanks > > gert > > > > 2013/2/21 雷钦 <[email protected]> > >> 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 >> > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
