arg, wrote too fast. If the data elements can contain commas, then csvtool -t COMMA -u TAB cat yourfile.csv > yourfile.tsv (convert to tab delimited) awk 'BEGIN{FS=OFS="\t"}{if (NF == 10){print $0}}' yourfile.tsv > goodfile.tsv csvtool -t TAB -u COMMA cat goodfile.tsv > loadablefile.csv On Mon, Jan 16, 2023 at 4:53 PM Kyle Banerjee <[log in to unmask]> wrote: > CSV is an unfortunate format because there's not a single accepted way to > do quoting and escaping. Excel is a problematic tool because it often does > things to your data that you don't want. > > Counting commas won't work unless none of your data fields contain commas. > However, if that happens to be a true statement, awk makes quick work of > the problem: > > awk 'BEGIN{FS=OFS=","}{if (NF == 10){print $0}}' yourfile.csv > > loadablefile.csv > awk 'BEGIN{FS=OFS=","}{if (NF != 10){print $0}}' yourfile.csv > > unloadablerecords.csv > > assuming you expect 10 fields. > > If values in your file might contain commas, translating it to something > else before analyzing simplifies things. Lots of ways to do this, csvtool > is particularly easy: > > csvtool -t COMMA -u TAB cat yourfile.csv > yourfile.tsv (convert to tab > delimited) > awk 'BEGIN{FS=OFS=","}{if (NF == 10){print $0}}' yourfile.tsv > > goodfile.tsv > csvtool -t TAB -u COMMA cat goodfile.tsv > loadablefile.csv > > kyle > > On Mon, Jan 16, 2023 at 4: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. >> Thanks! >> >> Cheers all, >> Max >> >> Maxwell Gray >> https://maxgray20.com >> >