Text function

This topic provides the Text functions available for an Expression activity.

Function

Returns

Description

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 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 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.

Left(string, length)

String

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

LeftTrim(string)

String

Removes spaces to the left of a string.

Length(string)

Number

Returns the number of characters in a string.

LowerCase(string)

String

Converts a specified string to lowercase.

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.

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.

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.

RightTrim(string)

String

Removes spaces to the right of a string.

ToString(value)

String

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

Trim(string)

String

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

UpperCase(string)

String

Converts a specified string to uppercase.

UrlEncode(string)

String

Encodes an URL string.