Skip to content

fmt.md

Latest commit

 

History

History
62 lines (43 loc) · 2.96 KB

fmt.md

File metadata and controls

62 lines (43 loc) · 2.96 KB
Raw

fmt

Reformat a CSV with different delimiters, record terminators or quoting rules. (Supports ASCII delimited data.)

Table of Contents | Source: src/cmd/fmt.rs

Description | Usage | Fmt Options | Common Options

Description ↩

Formats CSV data with a custom delimiter or CRLF line endings.

Generally, all commands in qsv output CSV data in a default format, which is the same as the default format for reading CSV data. This makes it easy to pipe multiple qsv commands together. However, you may want the final result to have a specific delimiter or record separator, and this is where 'qsv fmt' is useful.

For examples, see https://github.com/dathere/qsv/blob/master/tests/test_fmt.rs. See also https://github.com/dathere/qsv/wiki/Transform-and-Reshape#fmt

Usage ↩

qsv fmt [options] [<input>]
qsv fmt --help

Fmt Options ↩

       Option        Type Description Default
 ‑t,
‑‑out‑delimiter 		 string The field delimiter for writing CSV data. Must be a single character. "T" or "\t" can be used as shortcuts for tab. ,
 ‑‑crlf  flag Use '\r\n' line endings in the output.
 ‑‑ascii  flag Use ASCII field/record separators: Unit Separator (U+001F) for fields and Record Separator (U+001E) for records. Substitute (U+001A) is used as the quote character.
 ‑‑quote  string The quote character to use. Must be a single character. "
 ‑‑quote‑always  flag Put quotes around every value.
 ‑‑quote‑never  flag Never put quotes around any value.
 ‑‑escape  string The escape character to use. When not specified, quotes are escaped by doubling them.
 ‑‑no‑final‑newline  flag Do not write a newline at the end of the output. This makes it easier to paste the output into Excel.

Common Options ↩

     Option      Type Description Default
 ‑h,
‑‑help 		 flag Display this message
 ‑o,
‑‑output 		 string Write output to instead of stdout.
 ‑d,
‑‑delimiter 		 string The field delimiter for reading CSV data. Must be a single character. (default: ,)

Source: src/cmd/fmt.rs | Table of Contents | README