String Functions
The String functions include common functions that are used to manipulate string values. Geo SCADA Expert supports the following string functions:
- CHR—Allows formatting characters to be included in an expression.
- ELEMENT—Returns a single specified element extracted from a string of elements.
- FORMATVAL—Applies formatting to a value and returns the result as a string value.
- INSTRING—Returns a number that indicates the position of a substring in a string.
- LEFT—Returns a specified number of characters starting from the left of an input string.
- LEN—Returns the number of characters in an input string as a real value.
- MID—Returns a specified number of characters from an input string.
- RIGHT—Returns a specified number of characters starting from the right of an input string.
- STR—Returns the string equivalent of a value.
- TRANSLATE—Returns the application dictionary translation of a string expression in the current user locale.