csvquoted(
TEXT
)
The csvquoted( function adds quotes if necessary for CSV text (RFC 4180).
Parameters
This function has one parameter:
text – the original text.
Description
This function can assist with exporting CSV text (see RFC 4180). If the text contains a comma, double quote ("), carriage return or linefeed, it is surrounded with double quotes, and any double quotes within the text are turned into 2 double quotes. Otherwise, the text is left alone.
csvquoted({David Smith}) ☞ David Smith
csvquoted({Smith, David}) ☞ "Smith, David"
csvquoted({John said "It's ready!"}) ☞ "John said ""It's ready!"""
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.
- 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.
- 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
| 10.0 | New | New in this version. |