sedcsv
NAME
sedcsv
– stream editor functionality for filtering and editing
columns in .csv files
SYNOPSIS
Usage: sedcsv [-d|-V] [-E] [-l] [-n] [OTHEROPTIONS] -f SCRIPTFILE DATAFILE
DESCRIPTION
Sedcsv
allows a small subset of sed(1)
operations to be performed
on a .csv file, where actions (including patterns) are applied to
specific columns in the "target" .csv file. The patterns themselves
are also taken from a .csv file. Patterns in columns in the script
file may be related to columns in the data file by column number or by
column name.
OPTIONS
general:
- -h, –help
- Print help and exit
- –detailed-help
- Print help, including all details and hidden options, and exit
- –full-help
- Print help, including hidden options, and exit
- -V, –version
- Print version and exit
debugging:
- -d, –debug
- Print random debugging messages
matching control:
- -f, –file=filename
- File holding sed-like script
- –backref-delimiters="<OPEN>","<CLOSE>"
- How backreferences (especially > 9) are delimited
- -E, –regexp-extended
- Script uses "extended regular expressions" (ERE) (default=off)
output control
- –print-labels
- Print out column labels (if they exist) with each new file. (default is, only if first file, or they differ from previous ones printed.)
- –no-print-labels
- Do not print out column labels.
- –quiet
- Print rows only if the 'p' command is evaluated.
CSV-specific options:
- –labels
- Both script and data .csv files have column labels (default=off)
- –script-labels
- The script .csv file has column labels (default=off)
- –data-labels
- The data .csv file has column labels (default=off)
- –validate
- make sure the contents of columns are valid .csv (default=off)
- –representation=ENUM
- how should the values of columns be represented? (possible values="csv", "neutral" default=`neutral')
- –ragged
- allow rows to have differing numbers of columns (default=off)
- –ignore-missing
- a guard for a column missing in the input data is assumed to "succeed" (default=off)