All Functions

; - Separator character

The semicolon [;] character is used as separator character when exporting your data to files.

  • For CSV files: The ; character is used to delimit each column (for example in Excel)
  • For SQL files: The semi colon is used to delimit columns in the database
  • For XML files: The ; character is used to delimit each data node
  • For JSON files: The ; character is used to delimit each value in the json array

Usage(s)

; Returns a semicolon character

Parameter(s)

This function has no parameters

Example(s)

Separator character when exporting to files

Pattern "column1;column2;column3" x 20 iterations

  • When eporting to CSV, this returns 20 rows of data with each 3 columns (when opened in a spreadsheet program like Excel or OpenOffice).


  • When eporting to XML, this returns 20 data nodes with with each 3 record nodes.


  • When eporting to JSON, this returns 20 arrays with with each 3 named values.



    • exporting delimited data to a spreadsheet

    See also

    tab - tab character nl - new line character