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 雷钦 <leiqin2...@gmail.com>
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
