Developer Documentation Library > UNICOM Intelligence Function Library > Text, categorical, and array functions
 
Text, categorical, and array functions
These functions can operate on a text value, a categorical value, or an array only. An error occurs if you attempt to operate one of the functions in this group on data of any other type.
Function
Description
Searches a string, a category list, or an array, for a specified substring, subcategory list, or subarray, and if it is found, returns its start position.
Returns a string containing the first characters from a string, a category list containing the first categories from a category list, or an array containing the first elements from an array.
Returns a Long containing the number of characters in a string, the number of categories in a category list, or the number of elements in an array.
Returns a string containing a number of characters from a position in a string, a category list containing a number of categories from a position in a category list, or an array containing a number of elements from a position in an array.
Returns a string containing the last characters from a string, a category list containing the last categories from a category list, or an array containing the last elements from an array.
The examples in this section are based on the variables in the Museum example Quanvert database.
See also
Categorical functions
Text functions
Date and time functions
Conversion functions
Random number functions
List functions
Miscellaneous functions
Value resolution
Category expressions
UNICOM Intelligence Function Library