Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
46
Conversion Functions
Function Description
BCDTOHEX
Converts an item from BCD format to hex format with the
high-order byte first, regardless of platform
BCDTOINT
Converts an item from BCD format to integer format. The
byte order depends on the machine on which the map is run
BCDTOTEXT
Converts the digits in a BCD item to a text item containing
the digits as a string of characters
CONVERT
Replaces each byte of a byte stream or text expression with
a byte from another byte stream or text expression. Can be
used to convert from EBCDIC to ASCII and from ASCII to
EBCDIC
DATETONUMBER
Returns an integer that results from counting the days from
January 1, 1865, to the specified date
DATETOTEXT
Converts a date object or expression to a text item
FROMBASETEN
Converts an integer to a text item that can be interpreted
as a number using positional notation of the base specified
FROMDATETIME
Converts a date/time item to a text string of a specified
format
FROMNUMBER
Converts a number to a text string of a specified format
HEXTEXTTOSTREAM
Returns a binary text stream whose value is the evaluation
of input character text represented by hex pairs
INT
Returns the integer portion of a number
NUMBERTODATE
Converts an integer to a date that is in CCYYMMDD
presentation. The integer is the number of days from
January 1, 1865, to the specified date
NUMBERTOTEXT
Converts a number to text that looks like the original object
PACK
Converts an integer to a text item that can be interpreted
as a packed decimal number
PACKAGE
Converts a group or item object to a text item, including its
initiator and terminator
SERIESTOTEXT
Converts a contiguous or non-contiguous series to a text