qvd2csv
(since EVL 2.4)
Read <file.qvd>
and write CSV file to <file.csv>
or standard output. It uses data
types from QVD header or from existing <evd>
file or from <inline_evd>
.
Synopsis
qvd2csv <file.qvd> [-o|--output=<file.csv>] [-d|--date=<format>] [-h|--header=<field_name>,...] [-n|--no-header] [-l|--null=<string>] [-q|--quote=<char>] [-s|--separator=<char>] [-t|--datetime=<format>] [-a|--dos-eol | -b|--mac-eol] [-v|--verbose] qvd2csv <file.qvd> (<evd>|-d <inline_evd>) [-o|--output=<file.csv>] [-h|--header=<field_name>,...] [-n|--no-header] [-a|--dos-eol] [-b|--mac-eol] [-v|--verbose] qvd2csv ( --help | --usage | --version )
Options
- -d, --data-definition=<inline_evd>
-
either this option or the file
<evd>
must be presented to use already defined EVD - -a, --dos-eol
-
output DOS end-of-line, i.e. CR+LF (‘\r\n’)
- -b, --mac-eol
-
output Mac end-of-line, i.e. CR (‘\r’)
- --date=<format>
-
use format argument for date data type
- -h, --header=<field_name>,...
-
use comma separated list of field names instead of header line, for example when you don’t want to use field names from QVD header.
- -l, --null=<string>
-
to specify what string is used for NULL values in CSV, empty string is allowed
- -n, --no-header
-
with this option it produces no header.
- -o, --output=<file.csv>
-
write output into
<file.csv>
instead of standard output - -q, --quote=<char>
-
to use a quote argument in EVD
- -s, --separator=<char>
-
use ‘sep="<char>"’ for each field (except the last one)
- -t, --datetime=<format>
-
use format for datetime data type
- -v, --verbose
-
print to STDERR info/debug messages
- --help
-
print this help and exit
- --usage
-
print short usage information and exit
- --version
-
print version and exit
Examples
- Having some.qvd, the command to produce CSV file with empty strings representing NULL values, dates
in format ‘DD.MM.YYYY’ and with Windows end-of-line (i.e. CRLF):
qvd2csv --null="" --date="%d.%m.%Y" --dos-eol -i some.qvd > some.csv