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


History

VersionStatusNotes
10.2UpdatedNow 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.0NewNew in this version.