Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
48
Logical Functions
Function Description
ALL
Evaluates a series of conditions and returns TRUE if they all
evaluate to TRUE; otherwise returns FALSE
EITHER
Returns the result of the first argument that does not
evaluate to NONE
IF
Evaluates a conditional expression, returning one value if
true, another if false
NOT
Tests a condition, returning TRUE if the condition is not true,
FALSE if the condition is true
OR
Evaluates a series of conditions and returns TRUE if at least
one evaluates to TRUE, otherwise returns FALSE
WHEN
Evaluates a condition; then, based on that evaluation,
evaluates another condition and returns TRUE or FALSE
Text Functions
Function Description
BCDTOTEXT
Converts the digits in a BCD item to a text item containing
the digits as a string of characters
COUNTSTRING
Returns an integer representing the number of times that a
specified character string appears in a given character string
DATETOTEXT
Converts a date object or expression to a text item
FILLLEFT
Returns a text item of the specified length. The output is
right justified and is filled on its left with the specified pad
value
FILLRIGHT
Returns a text item of the specified length. The output is
left justified and is filled on its right with the specified pad
value
FIND
Returns the position in a text string at which another
specified text string begins