Function ISNUMERIC

TABLE OF CONTENTS

  1. How do I use ISNUMERIC?
  2. Syntax
  3. Rules for the syntax
  4. Examples: ISNUMERIC function in ERF
  5. Examples: ISNUMERIC function in ECL

How do I use ISNUMERIC?

The ISNUMERIC function returns true if the specified field has a numeric value, and false if the value is anything else.

The field can be a source field or a field from a lookup.

ISNUMERIC can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

(Syntax Legend)

Syntax

Function ISNUMERIC 1

Function ISNUMERIC 2

Function ISNUMERIC 3

Function ISNUMERIC 4

Function ISNUMERIC 5

Rules for the syntax

ISNUMERIC can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

If this functions checks a lookup, and no effective date is specified, the lookup uses RUNDAY( ) - see topic: Syntax - function RUNDAY

See also topic: Rules for all Logic Text

Examples: ISNUMERIC function in ERF

Example logic text Meaning
IF ISNUMERIC({field5})
    THEN SELECT
ENDIF		 Select all input records where field5 is numeric, and skip all other records.
This example is the same as:
    SELECTIF(ISNUMERIC({field5}))

Examples: ISNUMERIC function in ECL

Example logic text Meaning
IF ISNUMERIC({field6})
    THEN COLUMN = {field6} * 100
    ELSE COLUMN = 0
ENDIF		 If field6 for the current record is numeric,
then set the current column to field6 times 100,
otherwise set the current column to zero.