.\" DO NOT MODIFY THIS FILE! It was generated by help2man 1.47.16. .TH CSVLOOK "1" "October 2020" "csvlook 1.0.5" "User Commands" .SH NAME csvlook \- manual page for csvlook 1.0.5 .SH DESCRIPTION usage: csvlook [\-h] [\-d DELIMITER] [\-t] [\-q QUOTECHAR] [\-u {0,1,2,3}] [\-b] .IP [\-p ESCAPECHAR] [\-z FIELD_SIZE_LIMIT] [\-e ENCODING] [\-L LOCALE] [\-S] [\-\-blanks] [\-\-date\-format DATE_FORMAT] [\-\-datetime\-format DATETIME_FORMAT] [\-H] [\-K SKIP_LINES] [\-v] [\-l] [\-\-zero] [\-V] [\-\-max\-rows MAX_ROWS] [\-\-max\-columns MAX_COLUMNS] [\-\-max\-column\-width MAX_COLUMN_WIDTH] [\-y SNIFF_LIMIT] [\-I] [FILE] .PP Render a CSV file in the console as a Markdown\-compatible, fixed\-width table. .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\-L\fR LOCALE, \fB\-\-locale\fR LOCALE Specify the locale (en_US) of any formatted numbers. .TP \fB\-S\fR, \fB\-\-skipinitialspace\fR Ignore whitespace immediately following the delimiter. .TP \fB\-\-blanks\fR Do not convert "", "na", "n/a", "none", "null", "." to NULL. .TP \fB\-\-date\-format\fR DATE_FORMAT Specify a strptime date format string like "%m/%d/%Y". .TP \fB\-\-datetime\-format\fR DATETIME_FORMAT Specify a strptime datetime format string like "%m/%d/%Y %I:%M %p". .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\-\-max\-rows\fR MAX_ROWS The maximum number of rows to display before truncating the data. .TP \fB\-\-max\-columns\fR MAX_COLUMNS The maximum number of columns to display before truncating the data. .TP \fB\-\-max\-column\-width\fR MAX_COLUMN_WIDTH Truncate all columns to at most this width. The remainder will be replaced with ellipsis. .TP \fB\-y\fR SNIFF_LIMIT, \fB\-\-snifflimit\fR SNIFF_LIMIT Limit CSV dialect sniffing to the specified number of bytes. Specify "0" to disable sniffing entirely. .TP \fB\-I\fR, \fB\-\-no\-inference\fR Disable type inference when parsing the input. .SH "SEE ALSO" The full documentation for .B csvlook is maintained as a Texinfo manual. If the .B info and .B csvlook programs are properly installed at your site, the command .IP .B info csvlook .PP should give you access to the complete manual.