Returns the length of the provided text string. This macro is useful in combination with the substring and/or calculation macro function.

Returns the provided text in lower case.

Returns the provided text in UPPER CASE.

Turns the first letter of the provided text into lower case.

Turns the first letter of the provided text into UPPER CASE.

Turns the first letter of each word of the provided text into lower case.

Turns The First Letter Of Each Word Of The Provided Text Into Upper Case.

Removes any leading and/or trailing space characters of the provided text.

Removes any leading space characters of the provided text.

Removes any trailing space characters of the provided text.

Returns the position of the first occurrence of a provided text inside the provided text.

It returns 0 if the search term is not found.

This macro function is case-sensitive.

Replaces the provided text in the provided Text.

This macro is case-sensitive.

To replace a pipe char (the vertical dash |), it needs to be "escaped" with another pipe char.

Extracts the partial string beginning at the position as defined with the provided length.

Example: You can extract 5 characters beginning from the 2rd character of a text.

Extracts a partial string from a provided text based on a RegEx term.

Multiple found items can be separated with a separator char (use ASCII codes such as #10 or #13 for ENTER, etc.).

• Regular expressions

Returns the position of the last occurrence of one string, "needle", in another, "haystack". (See also the POS function).

It returns 0 if "needle" is the null string or is not found. By default the search starts at the last character of "haystack" and scans backward.

This macro function is case-sensitive.