Cvg
Examples
cvg --present colA input.csv
cvg --missing colA input.csv
cvg --match 'colA:/\d+/' input.csv
cvg --match 'colA:one,two,three,/\d+/' input.csv
cvg --detect-missing input.csv
cvg --lt 'colA:5' input.colA
cvg --limit 5 input.csv
Multiple tests:
cvg --present colA --missing colB input.csv
Multi files: (different column order OK)
cvg --present colA input1.csv input2.csv
TODO
DONE allows special "PRESENT" filter
DONE takes multiple csvs as input
DONE allows special "FALSE_OR_BLANK" filter
DONE combines tests
DONE allows single string matching
DONE allows multiple option matching
DONE allows regex matching
DONE allows > >= < <= comparisons
DONE treat as missing %w{ N/A n/a NULL null - #DIV/0 #REF! #NAME? NIL nil NA na #VALUE! #NULL! NaN #N/A #NUM! ? }
writes report (why rejected row, checks missing and extra columns across input files)
DONE dup checks on certain cols
optionall uses minimal set of headers shared by all
make it possible to match a field that starts with a /