Text Functions

When working with formulas one can use predefined functions listed in the table below:

Name Brief description

ASCII

It returns ASCII code for the first symbol of the string.

Chr

It returns character corresponding to the specified ASCII code.

Contains

It returns whether a source string contains a searched substring.

EndsWith_

It returns whether a source string ends with the searched substring.

Find

It returns substring position index in string.

Left

It returns specified number of symbols from the beginning of the string.

Length_

It returns string length.

Max_

It returns the maximum from a and b by means of character by character string comparison.

Mid

It returns the string starting with the position with the "start" index.

Min_

It returns the minimum from a and b by means of character by character string comparison.

Replace

It returns the string, in which all substring instances are replaced with the other string.

Right

It returns specified number of symbols from the end of the string.

Space

It returns a string consisting of specified number of repeating spaces.

StartsWith_

It returns whether a source string starts with the searched substring.

ToLower

It returns a string in which all symbols are in lower case.

ToUpper

It returns a string, in which all symbols in the upper case.

Trim

It returns a string with deleted spaces at the beginning and at the end.

TrimEnd

It returns a string with deleted spaces at the end.

TrimStart

It returns a string with deleted spaces at the beginning of the string.

See also:

Functions Available in Expression Editor