Used in: gor/nor

INSET

The INSET command only passes rows where the column value is found in the setfile, unless the option -b is used. The setfile must be a single column file or a <(nor … ) expression.

Usage

gor ... | INSET setfile.txt -c PN

Options

-c column

The column which the lookup is based upon.

-cis

Case-insensitive column lookup.

-b

Return 1 (true) or 0 (false) to indicate set membership.

-n name

Override the default value output column name (inSet).

-not

Negate the condition, i.e. NOTINSET.

-ordered

Assume the data is ordered for the columns on which the lookup is based.

The -ordered flag can reduce the memory usage significantly, especially when the number of lines in the map file is high. Note that there are no checks to see if the order is correct - only use this option if the input stream and the map file is correctly ordered.