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


History

VersionStatusNotes
10.0NewNew in this version.