- BASE64TOTEXT
Use the BASE64TOTEXT decoding function to convert previously encoded data from BASE64 back to the original text.
- BCDTOHEX
The BCDTOHEX function converts an item from binary coded decimal (BCD) format to hexadecimal format.
- BCDTOINT
The BCDTOINT function converts an item from BCD (binary coded decimal) format to integer format.
- 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.
- CONVERT
The CONVERT function replaces each byte of a byte stream or text expression with a byte from another byte stream or text expression.
- DATETONUMBER
Use DATETONUMBER to perform arithmetic on dates.
- DATETOTEXT
The DATETOTEXT function converts a date object or expression to a text item.
- FROMBASETEN
You can use FROMBASETEN when you need to convert numbers to a base other than 10.
- FROMDATETIME
The FROMDATETIME function converts a date/time item to a text string of a specified format.
- FROMNUMBER
The FROMNUMBER function converts a number to a text string of a specified format.
- HEXTEXTTOSTREAM
The HEXTEXTTOSTREAM is the reverse of STREAMTOHEXTEXT.
- INT
You can use the INT function when you need only the integer portion of a number.
- NUMBERTODATE
You can use the NUMBERTODATE function to perform a calculation on a date.
- NUMBERTOTEXT
The NUMBERTOTEXT function converts a character number to a text item that looks like the original object.
- PACK
The PACK function converts an integer to a text item that can be interpreted as a packed decimal number.
- PACKAGE
The PACKAGE function converts a group or item object to a text item, including its initiator, terminator, and any delimiters it contains.
- QUOTEDTOTEXT
The QUOTEDTOTEXT decoding function converts a single (text or binary) data object in Quoted-Printable format to a single data object that represents the original text or binary object.
- 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.
- STREAMTOHEXTEXT
Use STREAMTOHEXTEXT to assign a character text value to a binary text stream item.
- SYMBOL
You can use SYMBOL to include a symbol in your output.
- TEXTTOBASE64
The TEXTTOBASE64 encoding function converts a text item to Base64 format.
- TEXTTOBCD
The TEXTTOBCD function converts a text item from decimal digits to BCD (Binary Coded Decimal) format.
- TEXTTODATE
The TEXTTODATE function converts text item from CCYYMMDD or YYMMDD format to a date.
- TEXTTONUMBER
Use TEXTTONUMBER to convert text to a number.
- TEXTTOQUOTED
The TEXTTOQUOTED encoding function converts a text or binary item to Quoted-Printable format.
- 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.
- TOBASETEN
The TOBASETEN function converts a text item that can be interpreted as a number, using positional notation of the base specified, to a base 10 number.
- 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.
- UNPACK
You can use the UNPACK function to do arithmetic with a packed decimal number or to move a packed decimal value into a numeric item.
- UNZONE
You can use the UNZONE function to convert a text item that represents a zoned (signed) number to an integer.
- ZONE
Use ZONE to convert a number to a zoned (signed) number.