.\" Man page generated from reStructuredText.
.
.
.nr rst2man-indent-level 0
.
.de1 rstReportMargin
\\$1 \\n[an-margin]
level \\n[rst2man-indent-level]
level margin: \\n[rst2man-indent\\n[rst2man-indent-level]]
-
\\n[rst2man-indent0]
\\n[rst2man-indent1]
\\n[rst2man-indent2]
..
.de1 INDENT
.\" .rstReportMargin pre:
. RS \\$1
. nr rst2man-indent\\n[rst2man-indent-level] \\n[an-margin]
. nr rst2man-indent-level +1
.\" .rstReportMargin post:
..
.de UNINDENT
. RE
.\" indent \\n[an-margin]
.\" old: \\n[rst2man-indent\\n[rst2man-indent-level]]
.nr rst2man-indent-level -1
.\" new: \\n[rst2man-indent\\n[rst2man-indent-level]]
.in \\n[rst2man-indent\\n[rst2man-indent-level]]u
..
.TH "CSVFORMAT" "1" "Jul 12, 2024" "2.0.1" "csvkit"
.SH NAME
csvformat \- csvformat Documentation
.SH DESCRIPTION
.sp
Convert a CSV file to a custom output format.:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
usage: csvformat [\-h] [\-d DELIMITER] [\-t] [\-q QUOTECHAR] [\-u {0,1,2,3}] [\-b]
                 [\-p ESCAPECHAR] [\-z FIELD_SIZE_LIMIT] [\-e ENCODING]
                 [\-L LOCALE] [\-S] [\-H] [\-K SKIP_LINES] [\-v] [\-l] [\-\-zero] [\-V]
                 [\-E] [\-D OUT_DELIMITER] [\-T] [\-A] [\-Q OUT_QUOTECHAR]
                 [\-U {0,1,2,3}] [\-B] [\-P OUT_ESCAPECHAR]
                 [\-M OUT_LINETERMINATOR]
                 [FILE]

Convert a CSV file to a custom output format.

positional arguments:
  FILE                  The CSV file to operate on. If omitted, will accept
                        input as piped data via STDIN.

optional arguments:
  \-h, \-\-help            show this help message and exit
  \-E, \-\-skip\-header     Do not output a header row.
  \-D OUT_DELIMITER, \-\-out\-delimiter OUT_DELIMITER
                        Delimiting character of the output file.
  \-T, \-\-out\-tabs        Specify that the output file is delimited with tabs.
                        Overrides \(dq\-D\(dq.
  \-A, \-\-out\-asv         Specify that the output file is delimited with the
                        ASCII unit separator and record separator. Overrides
                        \(dq\-T\(dq, \(dq\-D\(dq and \(dq\-M\(dq.
  \-Q OUT_QUOTECHAR, \-\-out\-quotechar OUT_QUOTECHAR
                        Character used to quote strings in the output file.
  \-U {0,1,2,3}, \-\-out\-quoting {0,1,2,3}
                        Quoting style used in the output file: 0 quote
                        minimal, 1 quote all, 2 quote non\-numeric, 3 quote
                        none.
  \-B, \-\-out\-no\-doublequote
                        Whether or not double quotes are doubled in the output
                        CSV file.
  \-P OUT_ESCAPECHAR, \-\-out\-escapechar OUT_ESCAPECHAR
                        Character used to escape the delimiter in the output
                        CSV file if \-\-quoting 3 (\(dqQuote None\(dq) is specified
                        and to escape the QUOTECHAR if \-\-out\-no\-doublequote is
                        specified.
  \-M OUT_LINETERMINATOR, \-\-out\-lineterminator OUT_LINETERMINATOR
                        Character used to terminate lines in the output file.
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
See also: \fI\%Arguments common to all tools\fP\&.
.SH EXAMPLES
.sp
Convert a comma\-separated file to a pipe\-delimited file:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
csvformat \-D \(dq|\(dq examples/dummy.csv
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Convert to carriage return line\-endings:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
csvformat \-M $\(aq\er\(aq examples/dummy.csv
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
Convert to a tab\-delimited file (TSV) with no doubling of double quotes:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
printf \(aqkey,value\en1,\(dqa \(dq\(dqquoted\(dq\(dq string\(dq\(aq | csvformat \-T \-Q🐍
.ft P
.fi
.UNINDENT
.UNINDENT
.sp
To avoid escaping quote characters when using \fB\-\-quoting 3\fP, add \fB\-\-out\-quotechar \(dq\(dq\fP:
.INDENT 0.0
.INDENT 3.5
.sp
.nf
.ft C
csvformat \-u3 \-U3 \-Q🐍 examples/optional_quote_characters.csv
.ft P
.fi
.UNINDENT
.UNINDENT
.SH AUTHOR
Christopher Groskopf and contributors
.SH COPYRIGHT
2016, Christopher Groskopf and James McKinney
.\" Generated by docutils manpage writer.
.