Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
55
Inspection Functions
Function Description
ABSENT
Tests for the absence of an object
CONTAINSERRORS
Tests a valid object to see whether it contains any objects
in error
ISALPHA
Tests a text object to see whether it contains all alphabetic
characters
ISERROR
Tests an object to see whether it is in error
ISLOWER
Tests a text object to see whether it is 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 all uppercase
alphabetic characters
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
PARTITION
Checks whether an object is within a certain partition
PRESENT
Tests for the presence of an object
TESTOFF
Tests a specified bit in a binary number to see whether it
is off
TESTON
Tests a specified bit in a binary number to see whether it
is on
VALID
Returns the result of the first argument if it is valid;
otherwise, returns the second argument