Developer Documentation Library > UNICOM Intelligence Function Library > Text functions
 
Text functions
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 might come from elsewhere.
Returns a string from the standard texts for the required language, context, and label type.
Creates a string representing the hexadecimal value of a number.
Converts a string to lowercase.
Removes leading spaces from a string.
Replaces characters that are not allowed in the name of an MDM object, to produce a valid name.
Concatenates one or more values into a string.
Creates 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.
Tests whether a string matches a supplied regular expression.
Removes trailing spaces from a string.
Returns an array that contains substrings.
Removes leading spaces and trailing spaces from a string.
Converts a string to uppercase.
Returns the number of words in a string.
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