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 functions

Bottom

Cotan

Top

Date functions

DateAdd

DatePart

ExcelDate (only available in the application)

File functions

FileList

FileName

FilePath

Type functions

IsDate

IsDefined

IsElement

IsNull

String functions

EndsWith

IndexOf

PadLeft

PadRight

Split

StartsWith

Str

Substr

Other

ExcelMetaData

GetValueAt

Extensions to the language

Case statement