Text Functions

The list of predefined text functions is given in the table below:

Function	Brief description
_T	It determines whether the value can be converted to string type.
Concatenate	Returns the result of merging two or more text strings into one.
Exact	Returns whether two text strings are exactly the same.
Find	Returns one text string within another and returns its position.
Fixed	Returns the result of rounding a number to the specified number of decimals after the decimal separator.
Left	Returns the specified number of characters from the start of a text string.
Len	Returns string length.
Lower	Returns the result of string characters conversion to lowercase.
Mid	Returns a substring from a specified string based on starting position and length.
Replace	Replaces part of a text string with a different text string.
Rept	Returns a string repeated for the specified number of times.
Right	Returns the specified number of characters from the end of a text string.
Trim	It deletes spaces at the beginning and at the end of the specified string.
Upper	Returns the result of string conversion to uppercase.
Value	Returns the result of converting a text view of a number into numeric view.