IF statements (Format-Phase Column Logic)

TABLE OF CONTENTS

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

How do I use IF statements?

IF statements can be part of any logic text. An IF statement allows a condition to control the execution of one or more statements.

Even though IF statements are allowed in all logic text, the statements that can be called in an IF statement change depending on the particular logic text.

An IF statement can call another IF statement - this is called “nesting” of IF statements, and is allowed in all logic text.

The syntax details of an IF statement in Format-Phase Column Logic are shown below.

Syntax

Rules for the syntax

See also topic: Rules for all Logic Text

Examples: IF with COLUMN & COL.nnn (FCL)

You must set a value of COLUMN. In this logic text, you cannot set the value of COL.nnn - you can only enquire on the value of a column between 1 and the current column (inclusive).

Example logic text	Meaning
IF (Col.7 = 999)     THEN COLUMN = “TOTAL” ENDIF	If column 7 is 999 then set the 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 the current column to column 3 times column 4. The current column must be to the right of Column 7.
IF (Col.2 = Col.3)     THEN COLUMN = ALL(“-“) ENDIF	If column 2 equals column 3 then set the current column to all dashes. The current column must be to the right of Column 3.
IF (Col.2 = Col.3)     THEN COLUMN = REPEAT(“-“,13) ENDIF	If column 2 equals column 3 then set the current column to 13 dashes. The current column must be to the right of Column 3.
IF (Col.4 = “14733”)     THEN COLUMN = “\xFF” ENDIF	If column 4 is “14733” then set the current column to hexadecimal FF. The current column must be to the right of Column 4.