1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
=========
csvformat
=========
Description
===========
Convert a CSV file to a custom output format.:
.. code-block:: none
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: :doc:`../common_arguments`.
Examples
========
Convert a comma-separated file to a pipe-delimited file:
.. code-block:: bash
csvformat -D "|" examples/dummy.csv
Convert to carriage return line-endings:
.. code-block:: bash
csvformat -M $'\r' examples/dummy.csv
Convert to a tab-delimited file (TSV) with no doubling of double quotes:
.. code-block:: bash
printf 'key,value\n1,"a ""quoted"" string"' | csvformat -T -Q🐍
To avoid escaping quote characters when using :code:`--quoting 3`, add :code:`--out-quotechar ""`:
.. code-block:: bash
csvformat -u3 -U3 -Q🐍 examples/optional_quote_characters.csv
|
