Trim(String) Returns String with leading and trailing spaces removed. Result Type Text Examples Trim(" Bang! Bang! ") returns "Bang! Bang!".
Transpose (table) Transposes a tab/newline delimited table. This is useful to convert a table that has series data in rows—such as the results of the Analyse function—to one that has series data in columns, which is the format required for … Continue reading
Today () Returns today's date. Result Type Date Examples Today() would return 7/10/93 if evaluated on the same day that this manual entry was originally written.
Time () Similar to Today() except not rounded down to nearest midnight (i.e. has second accuracy). To be useful you need to format as text using a format that includes hours, minutes and seconds. Result Type Date Examples DateToText(Time(), -4) … Continue reading
TextToNum (text) Converts the given text to a numeric value. Use this when you need to perform arithmetic on the value. The text may contain thousands separators and a decimal separator. Leading spaces will be ignored. Result Type Number Examples … Continue reading
TextToDate (text [, format]) Converts the given text into a value of type date. Use this if, for example, you have a textual value representing a date, and you want to perform date arithmetic on it. If you don't explicitly … Continue reading
TestFlags (number, mask) Returns the bitwise AND of the arguments. Used for testing the Flags field in records. Result Type Integer Examples TestFlags(#00ff00ff, #23438313) returns 4390931 (hexadecimal #00430013) testflags(JobSheet.Flags, 1) returns 1 if the resource in the job sheet entry … Continue reading
Tail (listText, numberOfItems, delimiter) Returns the last numberOfItems items from a textual list of items. The list can be delimited by any character you like. If numberOfItems is negative, then Tail returns all but the first abs(numberOfItems) items of the … Continue reading
SumSelection ("filename.expression", searchExpression) Returns the sum of the nominated expression (which should be numeric) for the nominated searchExpression for the specified filename. Note that both parameters must be in quotes. When summing detail lines, use the SumDetail function. Result Type … Continue reading
SumDetail ("expression", detail.searchExpr, transaction.searchExpr) Used to get the sum of the nominated expression (which should return a numeric result) for the found detail lines of the found transactions. The detail lines to be found are identified in the first search … Continue reading