Function ISNOTSPACES

TABLE OF CONTENTS

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

How do I use ISNOTSPACES?

The ISNOTSPACES function returns true if the specified field is not spaces, and false if the value is spaces.

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

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

(Syntax Legend)

Syntax

Function ISNOTSPACES 1

Function ISNOTSPACES 2

Function ISNOTSPACES 3

Function ISNOTSPACES 4

Function ISNOTSPACES 5

Rules for the syntax

ISNOTSPACES 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: ISNOTSPACES function in ERF

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

Examples: ISNOTSPACES function in ECL

Example logic text Meaning
IF ISNOTSPACES({field3})
    THEN COLUMN = {field3}
    ELSE COLUMN = “NOT SET”
ENDIF		 If field3 for the current record is not spaces,
then set the current column to field3,
otherwise set the current column to “NOT SET”.