HiveBrain v1.2.0
Get Started
← Back to all entries
snippetbashTip

csvformat — Convert a CSV file to a custom output format. Included in csvkit. More information: <https://csvkit.

Submitted by: @import:tldr-pages··
0
Viewed 0 times
commandconvertclifilecsvformatcustomcsvoutput

Problem

How to use the csvformat command: Convert a CSV file to a custom output format. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvformat.html>.

Solution

csvformat — Convert a CSV file to a custom output format. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvformat.html>.

Convert to a tab-delimited file (TSV):
csvformat {{[-T|--out-tabs]}} {{data.csv}}


Convert delimiters to a custom character:
csvformat {{[-D|--out-delimiter]}} "{{custom_character}}" {{data.csv}}


Convert line endings to carriage return (^M) + line feed:
csvformat {{[-M|--out-lineterminator]}} "{{\r\n}}" {{data.csv}}


Minimize use of quote characters:
csvformat {{[-U|--out-quoting]}} 0 {{data.csv}}


Maximize use of quote characters:
csvformat {{[-U|--out-quoting]}} 1 {{data.csv}}

Code Snippets

Convert to a tab-delimited file (TSV)

csvformat {{[-T|--out-tabs]}} {{data.csv}}

Convert delimiters to a custom character

csvformat {{[-D|--out-delimiter]}} "{{custom_character}}" {{data.csv}}

Convert line endings to carriage return (^M) + line feed

csvformat {{[-M|--out-lineterminator]}} "{{\r\n}}" {{data.csv}}

Minimize use of quote characters

csvformat {{[-U|--out-quoting]}} 0 {{data.csv}}

Maximize use of quote characters

csvformat {{[-U|--out-quoting]}} 1 {{data.csv}}

Context

tldr-pages: common/csvformat

Revisions (0)

No revisions yet.