Find(string, string)

Number

Returns the position of the first occurrence of the first parameter string within the second parameter 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.

Contains(string, string)

Bool

Returns a true value if a substring, which is the first parameter, is found within the second parameter string. For example; To find the word "profit" in "Today XYZ company made a huge profit" string, use Contains function as Contains ("profit", "Today XYZ company made a huge profit").

LowerCase(string)

String

Converts a specified string to lowercase.

Left(string, length)

String

Returns a specified number of characters from the left side of a string.

Length(string)

Number

Returns the number of characters in a string.

LeftTrim(string)

String

Removes spaces to the left of a string.

RightTrim(string)

String

Removes spaces to the right of a string.

Trim(string)

String

Removes spaces from both the left and right of a string.

Mid(string, start)

String

Returns a specified number of characters from a string.

Mid(string, start, length)

String

Returns a specified number of characters from a string of a specified length.

Replace(string, find, replacewith)

String

Replaces a specified part of a string with another string.

Right(string, length)

String

Returns a specified number of characters from the right side of a string.

UpperCase(string)

String

Converts a specified string to uppercase.

PadLeft(string, length, character)

String

Pads a string with a padding character on the left side up to a specified length.

PadRight(string, length, character)

String

Pads a string with a padding character on the right side up to a specified length.

ToString(Value)

String

Converts a value to a string. The ToString function can be used in other functions, for example, Left(ToString(Now()),8)