Page History
NAME
csv2xml - CSV to XML format converter
SYNOPSIS
csv2xml [OPTION...] [-s] FILE...
csv2xml [OPTION...] [-o OUTPUT_FILE]
DESCRIPTION
Convert comma separated value (CSV) FILEs into extensible markup language (XML) files. The output file will have the same file name as FILE has with the file extension replaced with .xml. Output will be written to the standard output if -s option is specified.
If FILEs are not specified, csv2xml reads its input from standard input and writes output to standard output; the output can be redirected to a file by -o option.
The first line in the input is expected to be a row containing a list of column names by default; this can be turned off by -N option. If column names are not included in the input, a list of default column names are generated which follow 'columnN' naming convention where 'N' is an integer and starts from 1.
OPTIONS
If both short form and long form are specified on the command line, the long form will take precedence.
-c CHARSET
The character set to be used for encoding/decoding data; supported values are: 'UTF-8' and 'platform-default', default to 'UTF-8'.
-d DELIMITER
The delimiter for separating data; default to ','. Use word 'tab' for setting tab character as delimiter.
-l LINE_SEPARATOR
The line separator to be used in the output file; supported values are: 'unix', 'windows', default to platform's line separator.
-i
Prompt before overwriting the output file.
-N
Indicate the first line in the input is a row of data but not a row containing a list of column names.
-o OUTPUT_FILE
Redirect output to the file specified by OUTPUT_FILE if input is read from standard input.
-p
Preserve the last-modified time of the output file if it exists.
-s
Redirect output to the standard output if FILEs are specified.
-NT, --null-text BOOLEAN
Indicates if NULL value is represented as (null) text, default to 'false'. See BOOLEAN VALUES section below for supported BOOLEAN values.
-PA, --datetime PATTERN
Pattern for formatting date and time, default to 'yyyyMMdd HH:mm:ss.SSS'.
-PD, --date PATTERN
Pattern for formatting date, default to 'yyyyMMdd'.
-PT, --time PATTERN
Pattern for formatting time, default to 'HH:mm:ss.SSS'.
-SQ, --string-quote IDENTIFIER
String quoted identifier; supported values are: 'double-quote', 'single-quote', 'none', default to 'double-quote'.
BOOLEAN VALUES:
The followings are supported BOOLEAN values: 'true', 'false', 'yes', 'no', 'y', 'n', 'on', 'off', '1', '0'.
NOTES
On -o option, the .xml file extension will not be added to OUTPUT_FILE if OUTPUT_FILE does not have a file extension.
SEE ALSO