Not Locate

Filter:

NLOCATE

Syntax:

NLOCATE [columnrange] delimiter scan_string delimiter

Operands:

columnrange :: start_column - end_column
delimiter :: any character not used in the change strings
scan string :: a string of characters to match during scan
start_column :: integer | *
end_column :: integer | *

Functional Description:

Use the NLOCATE stage to select all records NOT containing a specified string or strings determined by an expression. The expression can be a character string.

All records that DO NOT contain the string or strings determined by the expression are written to the primary output stream in the order found in the input stream.

If the secondary output stream is connected, this filter writes all the records that DO contain the string by the expression to its secondary output stream. If the secondary output stream is not connected, this filter discards these records.

Secondary Input/Output:

OUTPUT

Synonyms:

NALL

Usage Notes:

The following example will select records that pass the NOT LOCATE criteria of ABC in record columns 20 through the end of the record:

| NLOCATE 20-* /ABC/ |

The following example will select records that pas the NOT LOCATE criteria of ABC in record columns 10 through 40 of the record and write the succesfully unmatched records to the primary output and the not successfully unmatched records to the secondary output stream.

|a: NLOCATE 20-* /ABC/ | ..... a:



JAVA Pipelines

Cullen Programming logo