Caltech Library logo

NAME

csvcols

SYNOPSIS

csvcols OPTIONS [ARGS_AS_COL_VALUES]

DESCRIPTION

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

-help
display help
-license
display license
-version
display version
-col, -cols
output specified columns (e.g. -col 1,12:14,2,4))
-d, -delimiter
set the input delimiter character
-i, -input
input filename
-o, -output
output filename
-od, -output-delimiter
set the output delimiter character
-quiet
suppress error messages
-skip-header-row
skip the header row
-trim-leading-space
trim leading space in field(s) for CSV input
-use-lazy-quotes
use lazy quotes on CSV input
-uuid
add a prefix row with generated UUID cell

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 1.2.9