On Tue, 22 Sep 2009, Simon Slavin wrote: > Use a text editor on the file and change all occurrences of (including the > quotes) > > "," > > to > > "|" > > then set .separator to the single character | before you import the > file.
Simon, The default separator is '|' (as confirmed by the .show command) so I changed all commas to the pipe. Makes no difference. Line 1 is still seen by SQlite as 26 columns for the expected 25 columns. Yet, when I count them I see only the 25. Just for the heck of it I added a pipe symbol to the end-of-line, but that doesn't make a difference either. Can't see what's causing the problem for some reason. Here's line 1 again (wrapped by alpine when pasted in): 117172|Engineered Structures Inc.|Brockway Center|10875 SW Herman Rd|Tualatin|97062-8033|Washington|NWR|45.3834|-122.7882|1542|Nonresidential Construct NEC|Gen12c(Agent)|Stormwater; NPDES Construction More Than 1 Acre Disturbed Ground|Issued By Agent|Minor|STM|Legal Contact|Engineered Structures Inc.|Gary|Ross|15940 SW 72nd Ave|Portland|OR|97224-7936|503-968-6639| There are no longer any commas in the file. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
