still
is a program for validating tabular data from CSV, TSV, and Excel.
Generate a schema. Directives start with @
and refer to global options. These are followed by column names and test expressions.
cars.schema
@separater TAB
mpg: is_numeric()
cyl: range(2,8)
hp: is_positive() && range(10, 500)
vs: is(0) || is(1)
am: any(0, 1)
Then run the command line tool:
still validate cars.schema cars.tsv
still
is largely influenced by csv-validate, but offers more flexibility when validating tabular data. Major differences include:
still
allows you to specify column indexes by their name, meaning columns can be in any order.still
can read Excel files