 |
 |
Hi again folks: Many thanks for everyone's replies yesterday evening! I retried fixing via OpenRefine, & no success. & I'm using double quotes for CSV comma enclosure. So I don't think commas inside values are the problem. (I've had success in the past with multiple different CSV files that included extra commas inside values & used double quotes for CSV comma enclosure, & so they weren't a problem.) RE: counting blanks in columns, Jackie Keith recommended using the COUNTBLANK formula at Excel/Google Sheets, which was easy to use, but still no success. (I didn't find any blanks in the data.) Anyway, I wanted to update folks, & say thanks again, everyone! Cheers all, Max Maxwell Gray https://maxgray20.com On Mon, Jan 16, 2023 at 8:59 PM Joe Hourclé <[log in to unmask]> wrote: > > On Jan 16, 2023, at 7:26 PM, Max <[log in to unmask]> wrote: > > > > Hi code4lib folks: > > > > Does anyone know a tool or hack to help fix a problem at a CSV that's > > causing a "The rows are not all the same number of columns." error when > > trying to import the CSV at a web application? I'm trying to use the CSV > > Import module <https://omeka.org/s/docs/user-manual/modules/csvimport/> > at > > Omeka S. I've had success in the past with different CSV files. But some > > kinda problem at the CSV I'm trying to import right now is causing this > > error, & reviewing the CSV in Excel & as plain text (literally counting > > commas to confirm rows are the same number of columns) isn't helping. > > I’ve been known to do a find/replace on commas, then set the tab width to > something very large and then look for the rows that don’t line up. > > But CSV is tricky, as it’s more than just commas that are significant, you > also have to consider quotations marks… which allow it so you can put > commas or line returns within a string field. > > -Joe > > Sent from a mobile device with a crappy on screen keyboard and obnoxious > "autocorrect" >