Function ISSPACES

TABLE OF CONTENTS

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

How do I use ISSPACES?

The ISSPACES function returns true if the specified field contains spaces, and false if the value is anything else.

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

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

(Syntax Legend)

Syntax

Function ISSPACES 1

Function ISSPACES 2

Function ISSPACES 3

Function ISSPACES 4

Function ISSPACES 5

Rules for the syntax

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

Example logic text Meaning
IF ISSPACES({field9})
    THEN SKIP
ENDIF		 Skip all input records where field9 is spaces, and select all other records.
This example is the same as:
    SKIPIF(ISSPACES({field9}))

Examples: ISSPACES function in ECL

Example logic text Meaning
IF ISSPACES({field1})
    THEN COLUMN = “DEFAULT”
    ELSE COLUMN = {field1}
ENDIF		 If field1 for the current record is spaces,
then set the current column to “DEFAULT”,
otherwise set the current column to field1.