csvexportlinevisiblecells(
)
The csvexportlinevisiblecells( function generates a comma delimited line of data containing all the visible (non hidden) fields in the current record.
Parameters
No parameters.
Description
The csvexportlinevisiblecells( function generates a comma delimited line of data containing all the visible (non hidden) fields in the current record. The line is generated in CSV format (see RFC 4180). Any non-text fields (numeric, date) will be converted to text as they are placed into the comma delimited line. The comma delimited line does not include a carriage return or linefeed character at the end.
If a field contains a comma, double quote ("), carriage return or linefeed, it is surrounded with double quotes, and any double quotes within the field are turned into 2 double quotes. Otherwise, the field is left unquoted.
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
- arraybuild -- builds an array by scanning a database and creating an array element for every record (including invisible records) in the database (see Text Arrays).
- arrayselectedbuild -- builds an array by scanning a database and creating an array element for every visible (selected) record in the database (see Text Arrays).
- csvexportline( -- generates a comma delimited line of data containing all the fields in the current record.
- csvquoted( -- adds quotes if necessary for CSV text (RFC 4180).
- databaseexportcsv -- exports selected records in the current database in CSV format (comma separated) to a text file.
- 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.
- exportline( -- generates a tab delimited line of data containing all the fields in the current record.
- exportlinenotabs( -- generates a tab delimited line of data containing all the fields in the current record. Any tabs *within* individual fields will be removed.
- HTML Export -- custom exports into an HTML file.
- savepartialdatabase -- saves specified components of the current database, leaving other components out.
- superarraybuild -- scans a database to create a text array. This statement is is similar to arraybuild, but with a number of additional options (see Text Arrays).
- 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
| 10.2 | Updated | Now uses a semicolon (;) instead of a period (.) as the field separator character if the system decimal point is set to comma instead of period. |
| 10.0 | New | New in this version. |