Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference PRESENT
Functions and Expressions Reference Guide
164
Related Function
GETPARTITIONNAME
PRESENT
The PRESENT function tests for the presence of an object.
Syntax
PRESENT (single-object-expression)
Meaning
PRESENT (object_to_look_for)
Returns
This function returns TRUE or FALSE
Returns TRUE if the input argument does not evaluate to NONE; the object is
present.
Returns FALSE if the input argument evaluates to NONE; the object is not
present.
Examples
PRESENT (Trailer:File)
This example returns TRUE if Trailer is present and returns FALSE if Trailer is
absent.
IF (PRESENT(MiddleInitial:.:Input), MiddleInitial:.:Input,
"***" )
This example in a map rule maps MiddleInitial if it is present. If
MiddleInitial is not present, three asterisks are mapped.
WHEN (PRESENT (AreaCode Field), PRESENT (PhoneNo Field))
In this example, PRESENT is being used in conjunction with the WHEN function
in a component rule to determine whether a particular object is valid.