Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
49
Function Description
HEXTEXTTOSTREAM
Returns a binary text stream whose value is the evaluation
of input character text represented by hex pairs
ISALPHA
Tests a text object to see whether it is contains all
alphabetic characters
ISLOWER
Tests a text object to see whether it is contains all
lowercase, alphabetic characters
ISNUMBER
Tests a text object to see whether it is a number
ISUPPER
Tests a text object to see whether it is contains all
uppercase, alphabetic characters
LEAVEALPHA
Removes characters that are not alphabetic from a specified
text item
LEAVEALPHANUM
Removes characters that are not alphabetic or numeric from
a specified text item
LEAVENUM
Removes non-numeric characters from a text item
LEAVEPRINT
Removes non-printable characters from a text item
LEFT
Returns a specified number of characters from a text item,
starting with the leftmost character
LOWERCASE
Converts a text item to lowercase characters
MAX
Returns the maximum value from a series of number, date,
time, or text values
MID
Extracts a specified number of characters from a text item,
starting at a specified position
MIN
Returns the minimum value from a series of number, date,
time, or text values
NUMBERTOTEXT
Converts a number to text that looks like the original object
OFFSET
Returns an integer representing the offset of the specified
object within the data, beginning at offset 0
PACKAGE
Converts a group or item object to a text item, including its
initiator and terminator