csvformat(1)

Overview

Convert a CSV file to a custom output format.:

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 "-D".
  -A, --out-asv         Specify that the output file is delimited with the
                        ASCII unit separator and record separator. Overrides
                        "-T", "-D" and "-M".
  -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
                        file.
  -P OUT_ESCAPECHAR, --out-escapechar OUT_ESCAPECHAR
                        Character used to escape the delimiter in the output
                        file if --quoting 3 ("Quote None") 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.

See also: Arguments common to all tools.

Examples

Convert a comma-separated file to a pipe-delimited file:

csvformat -D "|" examples/dummy.csv

Convert to carriage return line-endings:

csvformat -M $'\r' examples/dummy.csv

Convert to a tab-delimited file (TSV) with no doubling of double quotes:

printf 'key,value\n1,"a ""quoted"" string"' | csvformat -T -Q🐍

To avoid escaping quote characters when using --quoting 3, add --out-quotechar "":

csvformat -u3 -U3 -Q🐍 examples/optional_quote_characters.csv

Releases

4 releases since Debian 11 (Bullseye); the text changed 3 times.

--delimiter until Debian 12 (Bookworm); --encoding until Debian 12 (Bookworm); --escapechar until Debian 12 (Bookworm); --help until Debian 12 (Bookworm); --linenumbers until Debian 12 (Bookworm); --maxfieldsize until Debian 12 (Bookworm); --no-doublequote until Debian 12 (Bookworm); --no-header-row until Debian 12 (Bookworm); --out-delimiter until Debian 12 (Bookworm); --out-escapechar until Debian 12 (Bookworm); --out-lineterminator until Debian 12 (Bookworm); --out-no-doublequote until Debian 12 (Bookworm); --out-quotechar until Debian 12 (Bookworm); --out-quoting until Debian 12 (Bookworm); --out-tabs until Debian 12 (Bookworm); --quotechar until Debian 12 (Bookworm); --quoting until Debian 12 (Bookworm); --skip-lines until Debian 12 (Bookworm); --skipinitialspace until Debian 12 (Bookworm); --tabs until Debian 12 (Bookworm); --verbose until Debian 12 (Bookworm); --version until Debian 12 (Bookworm); --zero until Debian 12 (Bookworm); -B until Debian 12 (Bookworm); -D until Debian 12 (Bookworm); -H until Debian 12 (Bookworm); -K until Debian 12 (Bookworm); -M until Debian 12 (Bookworm); -P until Debian 12 (Bookworm); -Q until Debian 12 (Bookworm); -S until Debian 12 (Bookworm); -T until Debian 12 (Bookworm); -U until Debian 12 (Bookworm); -V until Debian 12 (Bookworm); -b until Debian 12 (Bookworm); -d until Debian 12 (Bookworm); -e until Debian 12 (Bookworm); -h until Debian 12 (Bookworm); -l until Debian 12 (Bookworm); -p until Debian 12 (Bookworm); -q until Debian 12 (Bookworm); -t until Debian 12 (Bookworm); -u until Debian 12 (Bookworm); -v until Debian 12 (Bookworm); -z until Debian 12 (Bookworm).