Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ISNUMBER
Functions and Expressions Reference Guide
135
ISNUMBER
The ISNUMBER function tests a text object to determine whether it contains all
numeric characters.
Syntax
ISNUMBER (single-text-expression)
Meaning
ISNUMBER (text_to_test)
Returns
This function returns TRUE or FALSE
If text_to_test contains only digits (for example, 0-9),
ISNUMBER evaluates to
TRUE.
If text_to_test contains other than digits,
ISNUMBER evaluates to FALSE.
Examples
ISNUMBER ("B1A4") returns FALSE
ISNUMBER ("1234") returns TRUE
ISNUMBER (PO#:Rec)
In the last example, if PO#:Rec contains only digits, ISNUMBER evaluates to
TRUE. If PO#:Rec contains any character that is not a digit,
ISNUMBER
evaluates to FALSE.
Uses
Use
ISNUMBER when you need to know whether a text item is all numeric
characters.
Related Functions
ISALPHA, ISLOWER, ISUPPER, LEAVEALPHA, LEAVEALPHANUM,
LEAVENUM, LEAVEPRINT