.\" DO NOT MODIFY THIS FILE! It was generated by help2man 1.47.16. .TH CSVSTACK "1" "October 2020" "csvstack 1.0.5" "User Commands" .SH NAME csvstack \- manual page for csvstack 1.0.5 .SH DESCRIPTION usage: csvstack [\-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] [\-g GROUPS] [\-n GROUP_NAME] [\-\-filenames] [FILE [FILE ...]] .PP Stack up the rows from multiple CSV files, optionally adding a grouping value. Files are assumed to have the same columns in the same order. .SS "positional arguments:" .TP FILE The CSV file(s) 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\-g\fR GROUPS, \fB\-\-groups\fR GROUPS A comma\-separated list of values to add as "grouping factors", one for each CSV being stacked. These will be added to the stacked CSV as a new column. You may specify a name for the grouping column using the \fB\-n\fR flag. .TP \fB\-n\fR GROUP_NAME, \fB\-\-group\-name\fR GROUP_NAME A name for the grouping column, e.g. "year". Only used when also specifying \fB\-g\fR. .TP \fB\-\-filenames\fR Use the filename of each input file as its grouping value. When specified, \fB\-g\fR will be ignored. .SH "SEE ALSO" The full documentation for .B csvstack is maintained as a Texinfo manual. If the .B info and .B csvstack programs are properly installed at your site, the command .IP .B info csvstack .PP should give you access to the complete manual.