Caltech Library logo

USAGE

csvcols [OPTIONS] [ARGS_AS_COL_VALUES]

SYNOPSIS

csvcols converts a set of command line args into columns output in CSV format. It can also be used CSV input rows and rendering only the column numbers listed on the commandline (first column is 1 not 0).

OPTIONS

    -col, -cols               output specified columns (e.g. -col 1,12:14,2,4))
    -d, -delimiter            set the input delimiter character
    -examples                 display example
    -generate-markdown-docs   generate markdown documentation
    -h, -help                 display help
    -i, -input                input filename
    -l, -license              display license
    -o, -output               output filename
    -od, -output-delimiter    set the output delimiter character
    -quiet                    suppress error messages
    -skip-header-row          skip the header row
    -uuid                     add a prefix row with generated UUID cell
    -v, -version              display version

EXAMPLES

Simple usage of building a CSV file one row at a time.

csvcols one two three > 3col.csv
csvcols 1 2 3 >> 3col.csv
cat 3col.csv

Example parsing a pipe delimited string into a CSV line

csvcols -d "|" "one|two|three" > 3col.csv
csvcols -delimiter "|" "1|2|3" >> 3col.csv
cat 3col.csv

Using a pipe filter a 3 column CSV for columns 1 and 3 into 2col.csv

cat 3col.csv | csvcols -col 1,3 > 2col.csv

Using options filter a 3 column CSV file for columns 1,3 into 2col.csv

csvcols -i 3col.csv -col 1,3 -o 2col.csv

csvcols v0.0.20-pre