Text Rules Functions

Rules to manage text in rules.

CAPIT
CAPIT applies initial capitalization to every word in a string.
CHAR
CHAR returns the character identified by a given ASCII numeric code.
CODE
CODE returns the ASCII numeric code for a specified character within a string.
CODEW
CODEW returns the UTF-8 numeric code for a specified character within a string.
DELET
DELET returns the result of deleting a specified number of characters from a specified starting point within a string.
FILL
FILL repeats a given string as necessary to return a string of a specified length.
INSRT
INSRT inserts one string into another string at a specified insertion point.
LONG
LONG returns the length of a string.
LOWER
LOWER converts all upper case characters in a string to lower case.
NUMBR
NUMBR converts a string to a number. The string passed to the NUMBR function must use. (period) as the decimal separator and , (comma) as the thousand separator. Any other decimal/thousand separators will cause incorrect results.
SCAN
SCAN returns a number indicating the starting location of the first occurrence of a specified substring within a string. If the substring does not occur in the given string, the function returns 0.
STR
STR converts a floating point number to a string representing the value in decimal notation.
SUBST
SUBST returns a substring of a given string.
TRIM
TRIM returns the result of trimming any leading and trailing blanks from a string.
UPPER
UPPER converts a text string to upper case.

Parent topic: Rules functions