Math Functions > General Functions


Replace Specific Values

The Replace Specific Values function replaces all occurrences of a specified value with another.  For example, you can use this function to change all occurrences of “1000” to “2000”.  If the data set contains precision information, then values within that precision limit will be replaced.  For example, if the precision of the data set is “1” (number of digits to the right of the decimal), then a value of “12.3” will replace all values between “12.25” and “12.35”.  If no precision is set, the values have to be exact to be replaced (not necessarily what is shown in a tabulation).  This function works on both time-series and paired data sets.

 

To replace specific values in time series or paired data sets:

  1. Choose the General tab of the Math Functions screen and select the Replace Specific Values operator.
  2. Select a data set to apply the function from the Selected Data Set pull-down list at the top of the screen or multiple data sets from the list in the lower portion of the screen.  If you include the data set selected in the top Selected Data Set, the operation on that set will only be done once. 
  3. In the Value to be replaced box, enter the value in the data sets that you want to be replaced.  If you want to replace missing values, leave this box empty.
  4. In the Value to replace with, enter the new number that you want to replace the specified number with.  If you want the value to be replaced to be set to missing, leave this box empty.
  5. Click Compute to perform the operation.