Trim

Trim(String) Returns String with leading and trailing spaces removed. Result Type Text Examples Trim(" Bang! Bang! ") returns "Bang! Bang!".

Posted in Functions | Comments Off on Trim

Transpose

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

Posted in Functions | Comments Off on Transpose

Today

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.

Posted in Functions | Comments Off on Today

Time

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

Posted in Functions | Comments Off on Time

TextToNum

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

Posted in Functions | Comments Off on TextToNum

TextToDate

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

Posted in Functions | Comments Off on TextToDate

TestFlags

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

Posted in Functions | Comments Off on TestFlags

Tail

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

Posted in Functions | Comments Off on Tail

SumSelection

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

Posted in Functions | Comments Off on SumSelection

SumDetail

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

Posted in Functions | Comments Off on SumDetail