COL.nnn in Extract-Phase Record Logic

TABLE OF CONTENTS

  1. How do I use COL.nnn in ERL?
  2. Syntax
  3. Examples: COL.nnn (ERL)
  4. Examples: IF with COL.nnn (ERL)

How do I use COL.nnn in ERL?

COL.nnn refers to a column value where nnn is the number of that column in the current view (starting at one on the leftmost column).

In ERL you can set the column value in any column in the view using a COL.nnn statement. You can also use COL.nnn in an enquiry, for example “IF (COL.nnn = ? “ ).

Note: The COLUMN statement refers to the current column, so is not applicable in ERL.

(Syntax Legend)

Syntax

Function COL.nnn ERL

Note: <Expression> is defined under IF statements

Rules for the syntax

COLUMN statements can not be used in Extract Record Logic.

See also topic: Rules for all Logic Text

Examples: COL.nnn (ERL)

Example logic text Meaning
COL.27 = {field1} * {field26}
COL.28 = {field14} + {field1}
COL.29 = 0
COL.30 = “ABC”		 Set column 27 to field1 times field26.
Set column 28 to field14 plus field1.
Set column 29 to zero.
Set column 30 to “ABC”.
COL.5 = {Lookup1.Field3} Set column 5 to Field3 found by
lookup path Lookup1

Examples: IF with COL.nnn (ERL)

Example logic text Meaning
IF ({field1} > 0) THEN
    COL.27 = {field1} * {field26}
    COL.28 = {field14} + {field1}
ELSE
    COL.27 = 0
    COL.28 = 0
ENDIF		 If field1 is greater than zero then set column 27
to field1 times field26 and set column 28 to field14
plus field1. If field1 is not greater than zero then
set columns 27 and 28 to zero.
IF COL.1 = ALL(“-“)
    THEN COL.2 = {field2} + {field3}
ENDIF		 If column 1 is all dashes, then set column 2
to a total of fields 2 and 3.