Changing data within excluded or non-excluded rows

If your data contains excluded and non-excluded rows, you can limit the effect of the CHANGE command to:

• Only non-excluded rows (parameter NX), or
• Only excluded rows (parameter EX or X)

For example, the following command changes all occurrences of the string GREEN, in column number 2 or column number 5 in non-excluded rows only, to the string BLACK:

CHANGE ALL GREEN BLACK (#2 #5) NX

And the following command changes the next occurrence of the value 250, in column number 2 in an excluded row, to 520:

CHANGE 250 520 #2 EX