On Sat, Sep 11, 2010 at 6:02 PM, Rich Shepard <rshep...@appl-ecosys.com>wrote:
> I cannot see what's wrong with a line in a .csv file. SQLite tells me it > expected 14 columns of data, but found 15. No matter how many times I count > the columns (exported in .csv from an OpenOffice.org Calc spreadsheet with > 14 columns), that's all I find. Nothing appears wrong with the following > line, either. And there's no extra space or char visible in emacs after the > final field's closing ". > > What should I look for that I haven't tried yet to find? > > Rich > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > When you saved the spreadsheet as a csv file, you probably took the default delimiter which happens to be a comma. You should check for a cell with data that has a comma in it. The embedded comma would be treated as a column separator which would result in the extra column. If you have an embedded comma, you have a couple of choices. You can fix the data and remove the comma. Alternatively, you can tell OpenOffice to use a different delimiter. Mel _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
