sddsderef

• description: sddsderef allows array and column dereferencing based on constants or on data in parameters and columns.

• examples: Let arrayData be a file containing a string array named MessageText and a column named MessageIndex containing integers. The integers are indices into the string array. To create a new column called Message giving the message text for each index, the following command would be used:
  sddsderef arrayData -column=Message,arraySource=MessageText,MessageIndex
• synopsis:
  sddsderef [input] [output] [-pipe[=input][,output]]
  -column=newName,{columnSource | arraySource}=name,indexName[,indexName1...]
  -parameter=newName,{columnSource | arraySource}=name, indexName[,indexName1...]
  -constant=newName,{columnSource | arraySource}=name, indexValue[,indexValue...]
  [-outOfBounds={exit | delete}]

• switches:
  • -pipe[=input][,output] -- The standard SDDS Toolkit pipe option.
  • -column=newName,{columnSource | arraySource}=name,indexName
    [,indexName1...] -- Creates a new column named newName containing values found by dereferencing the array (or column) name using the index or indices in the named columns.
  • -parameter=newName,{columnSource | arraySource}=name,indexName
    [,indexName1...] -- Creates a new parameter named newName containing values found by dereferencing the array (or column) name using the index or indices in the named parameters. A new value is thus generated for the parameter for each page.
  • -constant=newName,{columnSource | arraySource}=name,indexValue
    [,indexValue...] -- Creates a new parameter named newName containing values found by dereferencing the array (or column) name using the index or indices given (as explicit values). Unless the array (or column) varies from page to page, the new parameter will have the same value on each page.
  • -outBounds={exit | delete} -- Specifies behavior in the event that an index value is out of bounds (i.e., less than 0, or greater than or equal to the number of array elements or rows). If exit is given, the program aborts with an error; this is the default behavior. If delete is given, then the source row or page for the index is omitted from the output.
• author: M. Borland, ANL/APS.