4.72 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.
• examples: Use a list of quadrupole names to get just the Twiss parameters are the quadrupoles:

  sddsselect APS.twi quadNames.sdds APSquad.twi -match=ElementName -reuse

  where ElementName is a column in both APS.twi and quadNames.sdds giving the name of a magnet. Use the same file to get the Twiss parameters everywhere but at the quadrupoles:

  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 taken to be the same as columnName1. Data in columnName 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.
• sddsmselect — sddsmselect is a variant of sddsselect that permits multiple -match and -equate options for more sophisticated cross-referencing. In other respects, the program is used just like sddsmselect. sddsselect is much faster, however, for single-criterion matching or equating.
• see also:
  • Data for Examples
  • sddsxref
• author: M. Borland, H. Shang and R. Soliday ANL/APS.