2009/9/22 Rich Shepard <rshep...@appl-ecosys.com>: > 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|
Remove the trailing pipe character > > There are no longer any commas in the file. > > Rich Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
