Colin Hardwick wrote:
> 40009402 FUND NwL "NMF"NEAVB:GB;1 NQ NwL "NMF"NEAVB:GB;1 NQ
> 10000003 1991-02-14 1991-02-14
> 40009403 FUND Nwl'MF"NEA VB:GB;1 Q Nwl'MF"NEA VB:GB;1 Q
> 10000003 1991-02-14
>
> .mode tabs
> .import Feeds/Asset.txt Asset
>
> It appears the the shell tool is thrown by the (clearly) mismatched
> single and double quotes, but since I want it to use tabs as the
> separator should this be the case?
The shell tool always interprets double quotes as field delimiters; this
cannot be disabled without changing its source code.
> Of course I could write some code to look for strings like this and
> "fix" them, but then I won't end up with what the supplier has
> provided.
You could write some code to convert that file into some sensible
format. (Such as replacing line start with "INSERT INTO Asset VALUES('",
line end with "');", any tab with "','", and any ' with ''.)
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
