NAME

       csvsort - manual page for csvsort 1.5.0

DESCRIPTION

       usage: csvsort [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]

              [-p  ESCAPECHAR]  [-z  FIELD_SIZE_LIMIT]  [-e  ENCODING] [-L LOCALE] [-S] [--blanks] [--null-value
              NULL_VALUES [NULL_VALUES ...]]  [--date-format  DATE_FORMAT]  [--datetime-format  DATETIME_FORMAT]
              [-H]  [-K  SKIP_LINES]  [-v]  [-l] [--zero] [-V] [-n] [-c COLUMNS] [-r] [-i] [-y SNIFF_LIMIT] [-I]
              [FILE]

       Sort CSV files. Like the Unix "sort" command, but for tabular data.

   positional arguments:
       FILE   The CSV file to operate on. If omitted, will accept input as piped data via STDIN.

   options:
       -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.

       -L LOCALE, --locale LOCALE
              Specify the locale (en_US) of any formatted numbers.

       -S, --skipinitialspace
              Ignore whitespace immediately following the delimiter.

       --blanks
              Do not convert "", "na", "n/a", "none", "null", "." to NULL.

       --null-value NULL_VALUES [NULL_VALUES ...]
              Convert this value to NULL. --null-value can be specified multiple times.

       --date-format DATE_FORMAT
              Specify a strptime date format string like "%m/%d/%Y".

       --datetime-format DATETIME_FORMAT
              Specify a strptime datetime format string like "%m/%d/%Y %I:%M %p".

       -H, --no-header-row
              Specify that the input CSV file has no header row.  Will create default headers (a,b,c,...).

       -K SKIP_LINES, --skip-lines SKIP_LINES
              Specify  the  number  of  initial  lines  to  skip before the header row (e.g. comments, copyright
              notices, empty rows).

       -v, --verbose
              Print detailed tracebacks when errors occur.

       -l, --linenumbers
              Insert a column of line numbers at the front of the output. Useful when piping to  grep  or  as  a
              simple primary key.

       --zero When  interpreting  or  displaying column numbers, use zero-based numbering instead of the default
              1-based numbering.

       -V, --version
              Display version information and exit.

       -n, --names
              Display column names and indices from the input CSV and exit.

       -c COLUMNS, --columns COLUMNS
              A comma-separated list of column indices, names or ranges to sort by, e.g. "1,id,3-5". Defaults to
              all columns.

       -r, --reverse
              Sort in descending order.

       -i, --ignore-case
              Perform case-independent sorting.

       -y SNIFF_LIMIT, --snifflimit SNIFF_LIMIT
              Limit CSV dialect sniffing to the specified number of  bytes.  Specify  "0"  to  disable  sniffing
              entirely, or "-1" to sniff the entire file.

       -I, --no-inference
              Disable type inference when parsing the input.

SEE ALSO

       The  full  documentation for csvsort is maintained as a Texinfo manual.  If the info and csvsort programs
       are properly installed at your site, the command

              info csvsort

       should give you access to the complete manual.

csvsort 1.5.0                                       July 2024                                         CSVSORT(1)