Text functions

Contains(string, string)

Bool

Checks if text contains another string.

For example, to find the word "profit" in the "Today XYZ company made a huge profit" string, use the Contains function as: Contains ("profit", "Today XYZ company made a huge profit").

Find(string, string)

Number

Returns the position of a substring within a string.

The search begins at the first character of the second parameter string. This value will begin at 0 and will return -1 if it is not found.

Left(string, length)

String

Returns a specified number of characters from the start of the text.

LeftTrim(string)

String

Removes leading white space from the text.

Length(string)

Number

Returns the number of characters in the text.

LowerCase(string)

String

Converts text to lowercase.

Mid(string, start)

String

Extracts a portion of text starting at a position.

Mid(string, start, length)

String

Extracts a portion of text starting at a position.

PadLeft(string, length, character)

String

Pads text on the left to a specified length.

PadRight(string, length, character)

String

Pads text on the right to a specified length.

Replace(string, find, replacewith)

String

Replaces occurrences of a substring with new text.

Right(string, length)

String

Returns a specified number of characters from the end of text.

RightTrim(string)

String

Removes trailing whitespace from text

ToString(value)

String

Converts a value to its string representation.

The ToString function can be used in other functions, for example, Left(ToString(Now()),8)

Trim(string)

String

Removes leading and trailing whitespace from text.

UpperCase(string)

String

Converts text to uppercase.

UrlEncode(string)

String

Encodes text for use in URLs