When working with formulas one can use predefined functions listed in the table below:
Name | Brief description |
It returns ASCII code for the first symbol of the string. | |
It returns character corresponding to the specified ASCII code. |
|
It returns whether a source string contains a searched substring. | |
It returns whether a source string ends with the searched substring. | |
It returns substring position index in string. | |
It returns specified number of symbols from the beginning of the string. | |
It returns string length. | |
It returns the maximum from a and b by means of character by character string comparison. | |
It returns the string starting with the position with the "start" index. | |
It returns the minimum from a and b by means of character by character string comparison. | |
It returns the string, in which all substring instances are replaced with the other string. | |
It returns specified number of symbols from the end of the string. | |
It returns a string consisting of specified number of repeating spaces. | |
It returns whether a source string starts with the searched substring. |
|
It returns a string in which all symbols are in lower case. | |
It returns a string, in which all symbols in the upper case. | |
It returns a string with deleted spaces at the beginning and at the end. | |
It returns a string with deleted spaces at the end. | |
It returns a string with deleted spaces at the beginning of the string. |
See also: