csvformat

Type:command
Package:prepDATA/1.1 — Conversion, Transformation and Plotting of Basic Data Files
Namespace:&type1

Description

Convert a CSV file to a custom output format.

Usage

csvformat {options}
Bash equivalent: csvformat -d CSEP {options}
usage: csvformat [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]
[-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-S]
[–blanks] [-K SKIP_LINES] [-v] [-V] [-D OUT_DELIMITER] [-T]
[-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 on STDIN.
.
optional arguments:
-h, –help show this help message and exit
-d DELIMITER, –delimiter DELIMITER
Delimiting character of the input CSV file.
-t, –tabs Specify that the input CSV file is delimited with
tabs. Overrides “-d”.
-q QUOTECHAR, –quotechar QUOTECHAR
Character used to quote strings in the input CSV file.
-u {0,1,2,3}, –quoting {0,1,2,3}
Quoting style used in the input CSV file. 0 = Quote
Minimal, 1 = Quote All, 2 = Quote Non-numeric, 3 =
Quote None.
-b, –no-doublequote Whether or not double quotes are doubled in the input
CSV file.
-p ESCAPECHAR, –escapechar ESCAPECHAR
Character used to escape the delimiter if –quoting 3
(“Quote None”) is specified and to escape the
QUOTECHAR if –no-doublequote is specified.
-z FIELD_SIZE_LIMIT, –maxfieldsize FIELD_SIZE_LIMIT
Maximum length of a single field in the input CSV
file.
-e ENCODING, –encoding ENCODING
Specify the encoding of the input CSV file.
-S, –skipinitialspace
Ignore whitespace immediately following the delimiter.
–blanks Do not convert “”, “na”, “n/a”, “none”, “null”, “.” to
NULL.
-K SKIP_LINES, –skip-lines SKIP_LINES
Specify the number of initial lines to skip (e.g.
comments, copyright notices, empty rows).
-v, –verbose Print detailed tracebacks when errors occur.
-V, –version Display version information and exit.
-D OUT_DELIMITER, –out-delimiter OUT_DELIMITER
Delimiting character of the output CSV file.
-T, –out-tabs Specify that the output CSV file is delimited with
tabs. Overrides “-D”.
-Q OUT_QUOTECHAR, –out-quotechar OUT_QUOTECHAR
Character used to quote strings in the output CSV
file.
-U {0,1,2,3}, –out-quoting {0,1,2,3}
Quoting style used in the output CSV 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 (“Quote None”) is specified
and to escape the QUOTECHAR if –no-doublequote is
specified.
-M OUT_LINETERMINATOR, –out-lineterminator OUT_LINETERMINATOR
Character used to terminate lines in the output CSV
file.