COLUMN & COL.nnn statements
(Format-Phase Column Logic)

TABLE OF CONTENTS

1. How do I use COLUMN & COL.nnn statements in FCL?
2. Syntax for COLUMN in FCL
3. Examples: COLUMN (FCL)
4. Examples: IF with COLUMN (FCL)
5. Examples: IF with COL.nnn (FCL)

How do I use COLUMN & COL.nnn statements in FCL?

The COLUMN statement sets the value of the current column. A COLUMN statement is allowed in Format-Phase Column Logic.

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 the format phase, COL.nnn can only appear in an inquiry, for example “IF (COL.nnn = ? “ ). In Format-Phase Column Logic, the nnn must be the column number of a numeric column (aggregatable column), between 1 and the current column (inclusive).

Syntax for COLUMN in FCL

Note: <Arithmetic> and <Expression> are defined under IF statements

Rules for the syntax

You can only set the value of the current column using the COLUMN statement.

COL.nnn can only appear in an inquiry (for example “IF (COL.nnn = ? “ ). The nnn must be a column number between 1 and the current column (inclusive).

See also topic: Rules for all Logic Text

Examples: COLUMN (FCL)

Example logic text	Meaning
COLUMN = Col.3 * Col.4	Set current column to column 3 times column 4. The current column must be to the right of Column 4.
COLUMN = “TOTAL”	Set current column to “TOTAL”.
COLUMN = “\xFF”	Set current column to hexadecimal FF.

Examples: IF with COLUMN (FCL)

Example logic text	Meaning
IF (Col.7 = 999)     THEN COLUMN = “TOTAL” ENDIF	If column 7 is 999 then set current column to “TOTAL”. The current column must be to the right of Column 7.
IF (Col.7 = 999)     THEN COLUMN = Col.3 * Col.4 ENDIF	If column 7 is 999 then set current column to column 3 times column 4. The current column must be to the right of Column 7.
IF (Col.4 = “14733”)     THEN COLUMN = “\xFF” ENDIF	If column 4 is “14733” then set current column to hexadecimal FF. The current column must be to the right of Column 4.

Examples: IF with COL.nnn (FCL)

Example logic text	Meaning
IF (Col.7 = “X”)     THEN COLUMN = “TOTAL” ENDIF	If column 7 is “X” then set current column to “TOTAL”. The current column must be to the right of Column 7.
IF (Col.4 = “14733”)     THEN COLUMN = COL.2 ENDIF	If column 4 is “14733” then set the current column to column 2. The current column must be to the right of Column 4.
IF ((Col.4 + Col.5) * COl.6 > 1000)     THEN COLUMN = “\xFF” ENDIF	If column 4 and column 5 are added and then multiplied by column 6 and the result is greater than 1000 then set current column to hexadecimal FF. The current column must be to the right of Column 6.