Category: Functions

Extracts a segment from the front of a character string. Syntax $left(source,length) Parameters source a character string or an expression that evaluates to a character string length a number or an expression that evaluates to a number Return Value Character string, consisting of a string containing length characters from source, starting in the first position.…
Read more

Applies a mask pattern to the specified data item. For a more detailed explanation of mask patterns and their relation to data types, see Masking. Syntax $mask(item,pattern) Parameters item A value of any type or an expression that yields a value of any type; or An field of any data type. pattern The mask pattern…
Read more

Converts an expression to the character data type and sets the length of the result. Syntax $tocharacter(expression,length) Parameters expression Any value, or an expression that yields any value. length A number that specifies the number of characters in the resulting character string. Length can be a constant, a variable, a form field, or a parameter.…
Read more

Locates the first occurrence of a pattern in a character string. Syntax $position(source,pattern) Parameters source a character string, or an expression that evaluates to a character string pattern a character string, or an expression that evaluates to a character string Return Value Number, being the position of the first character in source that matches the…
Read more

Inserts a character string into another character string. Syntax $insert(source,position,string) Parameters source a character string, or expression that evaluates to a character string position a number or an expression that evaluates to a number string a character string, or expression that evaluates to a character string Return Value Character string consisting of source, with string…
Read more

Converts an expression to the alpha data type and sets the length of the result. Syntax $toalpha(expression,length) Parameters expression Any value, or an expression that yields any value. length A number. Can be a constant, a variable, a parameter, a menu item, or a form field. Return Value Character string (alpha), length bytes long. Comments…
Read more

Deletes a portion of a character string. Syntax $delete(source,position,length) Parameters source a character string or an expression that evaluates to a character string position a number or an expression that evaluates to a number length a number or an expression that evaluates to a number Return Value Character string, consisting of source, less those characters…
Read more

Checks whether a given Zim object exists in a Zim directory. Syntax $exist$(Zim directory name, object name, object type) Parameters Zim directory name A character string or an expression that evaluates to a character string, naming the ZIM directory to which the object would belong object name A character string or an expression that evaluates…
Read more

Run the methods of an ActiveX object. Syntax $ObjRun[Method] (Object, MethodName, «Parameters») Parameters Object an object variable or formfield of type OLE MethodName a string or an expression that evaluates to a string Parameters one or more optional arguments as per the specifications of the object Return Value Returns a result as per the specification…
Read more

Replaces segments of a character string with new text. Syntax $translate(source,pattern,replace) Parameters source a character string, or an expression that evaluates to a character string pattern a character string, or an expression that evaluates to a character string replace a character string, or an expression that evaluates to a character string Return Value Character string,…
Read more