Functions

Function

Description

_@MIN

Compare two or more values and return the smallest of them.

_@MAX

Compare two or more values and return the largest of them.

_@FIRST

Return the first in a list values that is non-zero.

Function

Description

_@MATCH

Compare two string for equality ( Case sensitive ).

_@IMATCH

Compare two strings for equality ( Not case sensitive ).

_@STRLEN

Returns the number of characters in a text string.

_@STRCMP

Compare two strings. Same as in C programming language ( Case sensitive ).

_@STRICMP

Compare two strings. Same as in C programming language ( Not case sensitive ).

_@FIND

Find if and where string_2 is contained within string_1 ( Case sensitive ).

_@IFIND

Find if and where string_2 is contained within string_1 ( Not case sensitive ).

_@RFIND

Find the last occurence of string_2 within string_1 ( Case sensitive ).

_@IRFIND

Find the last occurence of string_2 within string_1 ( Not case sensitive ).

_@SUBSTR

Extract a string from within another string.

_@CAT

Combines two or more text strings into a single text string.

_@CAPS

Returns a copy of the text string passed as an argument, with the first letter in each word capitalized.

_@LOWER

Returns a copy of the text string passed as an argument, with all characters coverted to lower case.

_@UPPER

Returns a copy of the text string passed as an argument, with all characters coverted to upper case.

Function

Description

_@ISSET

Display categories going forward in time by base time.