tabular-cli

    1.0.0 • Public • Published

    tabular-cli

    Detects and normalizes tabular data (dsv, json, ndjson, xls, xlsx, xml, ods or sylk) and converts it to dsv, json, ndjson, or ssejson. Spreadsheets and DSV must have a header.

    npm status Travis build status AppVeyor build status Dependency status

    examples

    To CSV

    npm i tabular-cli -g
    tabular -o csv < input.xlsx > output.csv
    

    To SSE JSON with snake_case keys

    npm i snake-case
    tabular -o sse -k snake-case --event status < status.tsv >> events.sse
    

    To JSON in the form of { "rows": .. } with missing values set to null

    tabular -o json --style object -d null < input.ndjson > output.json
    

    options

    --keys module (shorthand -k)

    An optional function to transform and/or filter keys, passed as a module name or location - relative to the current working directory or something installed alongside tabular-cli. For example: tabular -k snake-case or -k camel-case. Everything at change-case works well.

    --output format (shorthand -o)

    Output format, one of:

    • json: via format-data/json with additional options style, prefix, separator and suffix
    • ndjson: via ndjson
    • dsv: via csv-write-stream with additional options separator and no-headers (a boolean flag)
    • csv: shorthand for -o dsv --separator ,
    • tsv: shorthand for -o dsv --separator \t
    • sse: ssejson with additional option event

    The default is json.

    --default value (shorthand -d)

    Fallback value to use for null and undefined values. Default is 0. The CLI app coerces null, undefined, true, false or any number to a javascript type.

    --version

    Print version and exit.

    --help

    Open this readme in a browser and exit.

    install

    With npm do:

    npm install tabular-cli -g
    

    license

    MIT © Vincent Weevers. Test data © Statistics Netherlands, The Hague/Heerlen.

    Install

    npm i tabular-cli

    DownloadsWeekly Downloads

    1

    Version

    1.0.0

    License

    MIT

    Last publish

    Collaborators

    • vweevers