The IsDate() function assesses whether an element is a date. Related functions: IsDefined, IsElement, IsNull Syntax IsDate (Element) Element Any input value Note: If the

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. Related functions: Bottom Syntax Top (Array, No of rows) Array The input array No of

The SubStr() function returns part of a string. Note: SubStr() is an old function that is interchangeable with the Excel Mid() function. Mid() should be

The Str() function converts a numeric value to a string. Syntax Str (Value) Value Any value Examples Function Output Str(1.356) “1.356” Str(True) “True” Str(ABC) “ABC”

The StartsWith() function evaluates whether an input string starts with a specified set of characters. Related functions: EndsWith Syntax StartsWith (SpecifiedElement, Value) SpecifiedElement The input

The Split() function returns an array of strings from a single input, by separating the input string using a specified delimiter. Syntax Split (String, Delimiter)

The PadRight() function adds specified characters to the end of a string until it reaches a specified length. Related functions: PadLeft Syntax PadRight (String, Length,

The Padleft() function adds specified characters to the front of a string until it reaches a specified length. Related functions: PadRight Syntax Padleft (String, Length,