csvtool

all

Utility to filter and extract data from CSV formatted sources.

Options (3)

-c, --columnboolean

Extract the second column from a CSV file

Example: csvtool {{[-c|--column]}} {{2}} {{path/to/file.csv}}

-s, --searchboolean

Extract lines from a CSV file where the second column exactly matches `String`

Example: csvtool {{[-c|--column]}} {{2}} {{[-s|--search]}} '{{^String$}}' {{path/to/file.csv}}

-e, --no-headerboolean

Find lines in a CSV file where the second column ends with `Baz` and then extract the third and sixth columns

Example:

csvtool {{[-c|--column]}} {{2}} {{[-s|--search]}} '{{Baz$}}' {{path/to/file.csv}} | csvtool {{[-e|--no-header]}} {{[-c|--column]}} {{3,6}}

Extract the second column from a CSV file

csvtool [-c|--column] 2 path/to/file.csv

Extract the second and fourth columns from a CSV file

csvtool [-c|--column] 2,4 path/to/file.csv

Extract lines from a CSV file where the second column exactly matches `String`

csvtool [-c|--column] 2 [-s|--search] '^String$' path/to/file.csv

Extract lines from a CSV file where the second column starts with `Bar`

csvtool [-c|--column] 2 [-s|--search] '^Bar' path/to/file.csv

Find lines in a CSV file where the second column ends with `Baz` and then extract the third and sixth columns