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
