The ExportExcel() function takes a data block and exports it into an Excel workbook. The function can also append worksheets to existing Excel workbooks. This

The ExportCSV() function takes a data block and exports it into a CSV file. This function is only available in the Quintessence Language (for example,

The IsNullOrEmpty() function checks whether an element has no value assigned (i.e., it is null) or is an empty value. Unlike IsNull(), this function returns

The IsDefined() function determines whether an input parameter has a value assigned to it. Related functions: IsDate, IsElement, IsNull, IsNullOrEmpty Syntax: Examples: The examples provided below are based

The Quintessence language functions are useful ‘parser-type’ functions that are available in the Quintessence Application. They can also be used within expressions in Excel. Maths

The Top() function returns the first element of an array, or the first N elements when specified. Related functions: Bottom Syntax: Remarks: Examples: The examples

The SubStr() function returns a portion of a string. It uses zero based indexing, meaning the first character of a string is at position 0.

The Str() function converts a numeric, Boolean, or date value into a string. Syntax: Examples: The examples provided below are based on fictitious data for

The Startswith() function evaluates whether an input string starts with a specified sequence of characters. Related functions: Endswith Syntax: Examples: The examples provided below are based

The Split() function returns an array of strings created by splitting a single input string using a specified delimiter. Syntax: Examples: The examples provided below