Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
50
Function Description
PROPERCASE
Converts each "word" in a string, such that the first
alphabetic character is uppercase and the remaining
alphabetic characters are lowercase
REVERSEBYTE
Reverses the byte order of an item
RIGHT
Extracts a specified number of characters of a text item,
starting with the rightmost character
SERIESTOTEXT
Converts a contiguous or non-contiguous series to a text
item
SIZE
Returns, as an integer, the size of an object, exclusive of
any pad characters
SQUEEZE
Removes consecutive duplicates of a specified character
from a text item
STREAMTOHEXTEXT
Returns a character text stream represented by hex pairs
whose value is the evaluation of input binary text
SUBSTITUTE
Replaces specified text with other specified text in a text
item
TEXT
Converts a group or item object to a text item
TEXTTOBCD
Converts a text item from decimal digits to Binary Coded
Decimal (BCD) format
TEXTTODATE
Converts text that is in CCYYMMDD or YYMMDD
presentation to a date that looks like the text item
TEXTTONUMBER
Converts an object defined as text to an object defined as a
character number item
TEXTTOTIME
Converts an object defined as text to an object defined as
time
TIMETOTEXT
Converts a time object or expression to a text item
TODATETIME
Converts a text string of a specified format to a date/time
TONUMBER
Converts a text string of a specified format to a number
TRIMLEFT
Removes leading spaces (or another specified character)
from a text item