Simon,
> > On 6 Nov 2012, at 11:40am, Colin Hardwick <[email protected]> > wrote: > >> Line 1 of the import file is fine, but line 2 is rejected as only having 7 >> fields instead of 8. I've experimented with ".separator" commands to no >> avail (e.g. ".separator='\t'). 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 is trying to do the right thing, given its specifications. > You have some alternatives. > > One is to write your own simple importer program which interprets the saved > files how you want. > > Another is to use a shell command to pre-process the TSV file to replace your > quote characters with some unused character, then import that file, then use > SQL UPDATE commands to put the quote characters back again. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > Thanks for that. I'm getting old and slow, it's taken me a long time to realise that the sources for the shell are in the standard distribution! Peering at that at least clears up for me exactly what the import is doing now. We have this process running successfully under Windows, which confused me a bit. It seems that shell version 3.7.3 (which is what's running on the Windy system) actually works for us and imports the names as expected, but I just checked with the latest version and it fails in the same way as it does on the Mac. I'll do some pre/post-processing as you advise. Best regards, Colin Hardwick _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
