2009/9/22 Rich Shepard <rshep...@appl-ecosys.com>: > On Tue, 22 Sep 2009, Simon Davies wrote: > >> Remove the trailing pipe character > > Did that as soon as I learned it made no difference. Each line should be > clean and there are 25 columns defined in it. Quite frustrating.
> 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| But I count 26 pipe chars in your text above... > > Rich Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users