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 /