man page(1) manual page
Table of Contents

NAME

qddb_export - Export Qddb tables to various formats

SYNOPSIS

qddb_export csv ?options? <table_desc>
qddb_export as ?options? <table_desc>

Options:

-concatsheets on|off
(default: off)
-columntitles on|off
(default: off)
-rowtitles on|off
(default: off)
-dateformat "date format" -separator "single char separator" (default: ",")

DESCRIPTION

qddb_export accepts a table descriptor as used by the qddb_table command. The return value is a string suitable for immediate writing to a file for import by other applications. The most common and portable format is CSV (comma-separated fields).

csv
format produces an ASCII table in CSV format suitable for import by many applications. String values are encapsulated with double quotes, and any double quotes in the value are replaced with space characters. Dates, integers, and real numbers are not encapsulated with double quotes, so you should make sure the destination application can read dates in the format you specify. Common date formats include days1900 (number of days since January 1, 1900), %m/%d/%Y (mm/dd/YYYY), and %d/%m/%Y (dd/mm/YYYY). The default date format is either %m/%d/%y or %d/%m/%y depending on whether you are using US or European dates.

as
format produces an ASCII string suitable for import directly into Applix(TM) Spreadsheets. The title of each table is used as the title for a separate sheet. Calculated fields are not currently translated to AS format, but the current value of each field is exported.

SEE ALSO

qddb_import(n), qddb_instance(n), qddb_keylist(n), qddb_rows(n), qddb_script(n), qddb_search(n), qddb_schema(n), qddb_tuple(n), qddb_view(n)

BUGS

None known.

ACKNOWLEDGEMENTS

Applix(TM) is a registered trademark of Applix, Inc.


Table of Contents