description: sddsselect excludes or includes rows from one file based on the presence of
matching data in another file. It is similar to sddsxref, but unlike that program does not
import data from the second file. sddsmselect is a variant that permits multiple -match
and -equate options for more sophisticated cross-referencing, but sddsselect is faster for
single-criterion matching or equating.
files: input1 is an SDDS file from which rows of data will be selected for inclusion in output. If
input1 contains multiple pages, they are processed separately. input2 is an SDDS file containing
rows of data to use in selecting data from input1. Warning: if output is not given and -pipe=output
is not specified, then input1 will be replaced.
switches:
-pipe[=input][,output] — The standard SDDS Toolkit pipe option.
-match=columnName1[=columnName2] — Specifies the names of string columns from
input1 and input2 to compare. If columnName2 is not given, it is taken to be the same
as columnName1. Data in columnName1 is taken from input1 and columnName2 from
input2. For each row in a page of input1, a match for the string in columnName1 is
sought in any row of columnName2. If a match is found, the row is accepted.
-equate=columnName1[=columnName2] — Identical to -match, except the columns
contain numerical data.
-invert — Specifies that only rows that have no match or equal should be selected for
output.
-reuse[=rows][,page] — By default, if input1 contains multiple pages, each is selected
against the corresponding page of input2. In addition, each row of input2 is matched or
equated to only one row of input1. If -reuse=page is given, then each page of input1 is
selected against the first page of input2. If -reuse=rows is given, each row of input2 can
select any number of rows of input1.
-noWarnings — Specifies that no warning messages (about, e.g., file length mismatches
or file overwrites) should be issued.