4.91 sddsselect

• 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.
• examples:
      sddsselect APS.twi quadNames.sdds APSquad.twi -match=ElementName -reuse  
      sddsselect APS.twi quadNames.sdds APSnquad.twi -match=ElementName -reuse -invert  
      

• synopsis:
      sddsselect [-pipe[=input][,output]] [input1] input2 [output] {-match=columnName1[=columnName2] |  
        -equate=columnName1[=columnName2]} [-invert] [-reuse[=page][,rows]] [-noWarnings]  
      

• 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.
• see also: sddsxref() sddsmselect()
• author: M. Borland, H. Shang and R. Soliday, ANL/APS.