.\" DO NOT MODIFY THIS FILE!  It was generated by help2man 1.47.16.
.TH CSVGREP "1" "October 2020" "csvgrep 1.0.5" "User Commands"
.SH NAME
csvgrep \- manual page for csvgrep 1.0.5
.SH DESCRIPTION
usage: csvgrep [\-h] [\-d DELIMITER] [\-t] [\-q QUOTECHAR] [\-u {0,1,2,3}] [\-b]
.IP
[\-p ESCAPECHAR] [\-z FIELD_SIZE_LIMIT] [\-e ENCODING] [\-S] [\-H]
[\-K SKIP_LINES] [\-v] [\-l] [\-\-zero] [\-V] [\-n] [\-c COLUMNS]
[\-m PATTERN] [\-r REGEX] [\-f MATCHFILE] [\-i] [\-a]
[FILE]
.PP
Search CSV files. Like the Unix "grep" command, but for tabular data.
.SS "positional arguments:"
.TP
FILE
The CSV file to operate on. If omitted, will accept
input as piped data via STDIN.
.SS "optional arguments:"
.TP
\fB\-h\fR, \fB\-\-help\fR
show this help message and exit
.TP
\fB\-d\fR DELIMITER, \fB\-\-delimiter\fR DELIMITER
Delimiting character of the input CSV file.
.TP
\fB\-t\fR, \fB\-\-tabs\fR
Specify that the input CSV file is delimited with
tabs. Overrides "\-d".
.TP
\fB\-q\fR QUOTECHAR, \fB\-\-quotechar\fR QUOTECHAR
Character used to quote strings in the input CSV file.
.TP
\fB\-u\fR {0,1,2,3}, \fB\-\-quoting\fR {0,1,2,3}
Quoting style used in the input CSV file. 0 = Quote
Minimal, 1 = Quote All, 2 = Quote Non\-numeric, 3 =
Quote None.
.TP
\fB\-b\fR, \fB\-\-no\-doublequote\fR
Whether or not double quotes are doubled in the input
CSV file.
.TP
\fB\-p\fR ESCAPECHAR, \fB\-\-escapechar\fR ESCAPECHAR
Character used to escape the delimiter if \fB\-\-quoting\fR 3
("Quote None") is specified and to escape the
QUOTECHAR if \fB\-\-no\-doublequote\fR is specified.
.TP
\fB\-z\fR FIELD_SIZE_LIMIT, \fB\-\-maxfieldsize\fR FIELD_SIZE_LIMIT
Maximum length of a single field in the input CSV
file.
.TP
\fB\-e\fR ENCODING, \fB\-\-encoding\fR ENCODING
Specify the encoding of the input CSV file.
.TP
\fB\-S\fR, \fB\-\-skipinitialspace\fR
Ignore whitespace immediately following the delimiter.
.TP
\fB\-H\fR, \fB\-\-no\-header\-row\fR
Specify that the input CSV file has no header row.
Will create default headers (a,b,c,...).
.TP
\fB\-K\fR SKIP_LINES, \fB\-\-skip\-lines\fR SKIP_LINES
Specify the number of initial lines to skip before the
header row (e.g. comments, copyright notices, empty
rows).
.TP
\fB\-v\fR, \fB\-\-verbose\fR
Print detailed tracebacks when errors occur.
.TP
\fB\-l\fR, \fB\-\-linenumbers\fR
Insert a column of line numbers at the front of the
output. Useful when piping to grep or as a simple
primary key.
.TP
\fB\-\-zero\fR
When interpreting or displaying column numbers, use
zero\-based numbering instead of the default 1\-based
numbering.
.TP
\fB\-V\fR, \fB\-\-version\fR
Display version information and exit.
.TP
\fB\-n\fR, \fB\-\-names\fR
Display column names and indices from the input CSV
and exit.
.TP
\fB\-c\fR COLUMNS, \fB\-\-columns\fR COLUMNS
A comma separated list of column indices, names or
ranges to be searched, e.g. "1,id,3\-5".
.TP
\fB\-m\fR PATTERN, \fB\-\-match\fR PATTERN
The string to search for.
.TP
\fB\-r\fR REGEX, \fB\-\-regex\fR REGEX
If specified, must be followed by a regular expression
which will be tested against the specified columns.
.TP
\fB\-f\fR MATCHFILE, \fB\-\-file\fR MATCHFILE
If specified, must be the path to a file. For each
tested row, if any line in the file (stripped of line
separators) is an exact match for the cell value, the
row will pass.
.TP
\fB\-i\fR, \fB\-\-invert\-match\fR
If specified, select non\-matching instead of matching
rows.
.TP
\fB\-a\fR, \fB\-\-any\-match\fR
If specified, select rows where any column matches
instead of all columns.
.SH "SEE ALSO"
The full documentation for
.B csvgrep
is maintained as a Texinfo manual.  If the
.B info
and
.B csvgrep
programs are properly installed at your site, the command
.IP
.B info csvgrep
.PP
should give you access to the complete manual.