- BCDTOTEXT
The BCDTOTEXT function converts the digits in a BCD (Binary Coded Decimal) item to a text item containing the digits of the BCD-encoded item as a string of characters.
- COUNTSTRING
You can use the COUNTSTRING function when you need to know the number of times a specific text string appears within another text string.
- CPACKAGE
The CPACKAGE specifies the character set of the output of the function.
- CSERIESTOTEXT
The CSERIESTOTEXT specifies the character set of the output of the function.
- CSIZE
The CSIZE function returns an integer representing the size of a specified object in characters, exclusive of any pad characters.
- CTEXT
The CTEXT specifies the character set of the output of the function.
- DATETOTEXT
The DATETOTEXT function converts a date object or expression to a text item.
- FILLLEFT
The FILLLEFT function returns a text item of the length specified. In the output, the text item is preceded with the specified pad value.
- FILLRIGHT
The FILLRIGHT function returns a text item of the length specified. In the output, the text item is appended with the specified pad value.
- FIND
The FIND function looks for one text string within another text string and returns to its starting position, if found.
- HEXTEXTTOSTREAM
The HEXTEXTTOSTREAM is the reverse of STREAMTOHEXTEXT.
- LEAVEALPHA
The LEAVEALPHA function removes all non-alphabetic characters from a specified text item.
- LEAVEALPHANUM
The LEAVEALPHANUM function removes all non-alphanumeric characters (such as symbols) from a specified text item.
- LEAVENUM
The LEAVENUM function removes all non-numeric characters from a text item.
- LEAVEPRINT
The LEAVEPRINT function removes all non-printable characters from a text item.
- LEFT
The LEFT function returns a specified number of characters from a text expression beginning with the leftmost byte of a text item.
- LOWERCASE
The LOWERCASE function converts an alphabetic text item to all lowercase characters.
- MAX
The MAX function returns the maximum value from a series of number, date, time, or text values.
- MID
You can use the MID function when you need specific characters from a text item.
- MIN
Use MIN when you need the minimum value from a series of number, date, time, or text values.
- NORMXML
Use this function to remove XML formatting from an input XML fragment.
- NUMBERTOTEXT
The NUMBERTOTEXT function converts a character number to a text item that looks like the original object.
- PACKAGE
The PACKAGE function converts a group or item object to a text item, including its initiator, terminator, and any delimiters it contains.
- PROPERCASE
Use PROPERCASE to convert the first alphabetic character in each word to uppercase and all remaining characters to lowercase.
- RANDDATA
The RANDDATA function returns random text based on the properties of the output type. The RAND function returns a pseudo-random integer between 0 and RAND_MAX (guaranteed to be at least 32,767). The RANDDATA function generates a valid random value of the item type that is being built when it is invoked. In other words, if the rule were "A:Card = RandData ()", the random value would be valid data for type "A"—where that type "A" is a component of the specified "Card". The type "A" can be text, a date/time object, or a number.
- REVERSEBYTE
Use the REVERSEBYTE function when you need the bytes in the opposite sequence.
- RIGHT
You can use RIGHT when you need a specific part of a text item.
- SEED
The SEED function primes the RAND and RANDDATA functions so they produce repeated results.
- SERIESTOTEXT
You can use the SERIESTOTEXT function to project your input data as a series and to interpret it as a text item for output.
- SQUEEZE
The SQUEEZE function removes consecutive duplicate occurrences of a specified character or characters from a text item.
- SUBSTITUTE
You can use the SUBSTITUTE function to replace or remove a character.
- TEXT
You can use the TEXT function to convert an object to a text item or when echoing entire data objects to another map.
- TEXTTOBCD
The TEXTTOBCD function converts a text item from decimal digits to BCD (Binary Coded Decimal) format.
- TEXTTONUMBER
Use TEXTTONUMBER to convert text to a number.
- TEXTTOTIME
Use TEXTTOTIME when you want to convert an object defined as text that is in HHMM or HHMMSS presentation, to an item defined as time.
- TIMETOTEXT
You can use the TIMETOTEXT function to perform text concatenation.
- TODATETIME
The TODATETIME function converts a text string of a specified format to a date-time item.
- TONUMBER
The TONUMBER function converts a text string of a specified format to a number.
- TRIMLEFT
You can use the TRIMLEFT function to remove spaces or a text string at the beginning of some text.
- TRIMRIGHT
You can use the TRIMRIGHT function to remove spaces or a text string at the end of text.
- UPPERCASE
The UPPERCASE function converts text to all uppercase characters.
- WORD
You can use the WORD function to parse a text item that is delimited by some character, such as a space or a comma.