Scripting > UNICOM Intelligence Function Library > Text functions
 
Text functions
These functions deal with Text data.
Function
Description
Returns an integer value representing the Unicode character code for a character.
Returns the character that corresponds to a given Unicode character code.
Returns a string that is the result of formatting a value according to one or more specified styles.
Identical to the Format function, except that the metadata to be used for formatting is provided by one variable, while the value to be formatted may come from elsewhere.
Returns a string representing the hexadecimal value of a number.
Returns a string that has been converted to lower case.
Returns a copy of a string with leading spaces removed.
Replaces characters that are not allowed in the name of an MDM object, to produce a valid name.
Returns a text string by concatenating one or more values.
Returns a string representing the octal value of a number.
Returns the first substring matched by the regular expression in the stringVal. Returns an empty string if a match was not found for the regular expression.
Returns a string formed by replacing the substrings that are matched by the regular expression in the string Val with another string.
Returns true if the Val string matches the supplied regular expression.
Returns a copy of a string with trailing spaces removed.
Returns an array that contains substrings.
Returns a copy of a string with both leading spaces and trailing spaces removed.
Returns a string that has been converted to upper case.
Specifying text strings as arguments
In an SQL query, enclose text strings in ' ' (single quotation marks).
In mrScriptBasic or mrScriptMetadata, enclose text strings in " " (double quotation marks).
See also
Categorical functions
Text, categorical, and array functions
Date and time functions
Conversion functions
Random number functions
List functions
Miscellaneous functions
UNICOM Intelligence Function Library