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"
>
|