databaseexportcsv
databaseexportcsv
TEXTFILE

The databaseexportcsv statement exports selected records in the current database in CSV format (comma separated) to a text file.

Parameters

This statement has one parameter:

textfile – path and name of text file, or “” to ask user.

Description

This statement exports selected records in the current database in CSV format (comma separated) to a text file. Only visible (non hidden) fields are included in the export. Here is an example that exports the selected records to a file named Mailing List.txt.

    databaseexportcsv "~/Dropbox/MailingList.txt"

Note: This statement is used by the File>Export>Text (CSV) menu command.

NOTE: Though usually this function outputs data with a comma character in between each exported field, a semicolon (`;`) is used instead if the System Preferences Language & Region panel specifies that the numeric decimal point character is set to a comma (as it is for many European countries) instead of a period. For example, in the United States this function will use a comma between each exported field, while in France it will use a semicolon (`;`). You can change this setting in the System Preferences Language & Region panel and Panorama will immediately change the export separator character – you don’t have to quit and relaunch Panorama.

See Also

- csvexportline( -- generates a comma delimited line of data containing all the fields in the current record.
- csvexportlinevisiblecells( -- generates a comma delimited line of data containing all the visible (non hidden) fields in the current record.
- csvquoted( -- adds quotes if necessary for CSV text (RFC 4180).
- databaseexporttsv -- exports selected records in the current database in TSV format (tab separated) to a text file.
- databaseexportusingformula -- exports selected records in the current database to a text file, using a formula.
- downloadpartialdatabase -- downloads specified components of the current database from the server. The current database must be shared.
- export -- exports the selected rows in the current database into a text file.
- HTML Export -- custom exports into an HTML file.
- savepartialdatabase -- saves specified components of the current database, leaving other components out.
- Text Export -- exporting a database into a text or HTML file.
- Text Export Wizard -- custom exports into a text or HTML file.
- tsvtocsv( -- converts tab separated text into comma separated text.
- tsvtojson( -- converts tab separated text into JSON formatted text.

History

Version | Status | Notes
10.0 | New | New in this version.