Text Functions

When working with formulas, the user 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.