NAME

uniqtbl - compare adjacent rows in an rdb table

SYNOPSIS

uniqtbl [options] column ...

OPTIONS

-D

Diagnostic output. Prints number of rows removed on STDERR.

-g

Group option. Instead of producing unique rows, produce only groups of repeated rows, with a blank row between. In this case the -D option shows the number of groups.

-r

Remove all repeated rows, not just the second and succeeding copies. This option does nothing in group mode.

-help

Print this help info.

-v

Inverse option. Selects all columns except those named.

-w file

write deleted rows to file

DESCRIPTION

uniqtbl Reads the input rdbtable and compares adjacent rows. The second and succeeding copies of repeated rows, considering only the selected columns, are removed. That is, adjacent rows are considered equal if the data values in all of the selected columns are equal. The remaining rows are written to the output rdbtable. Note that repeated rows must be adjacent in order to be found. Normally this means that the input rdbtable should be sorted on the selected columns for this capability to work properly.

This RDB operator reads an rdbtable from STDIN and writes an rdbtable to STDOUT. Options may be abbreviated.