RockWorks | Utilities | Columns | Filter
Use this RockWorks Utilities tool to remove or replace numeric values that fall below and/or above a specified value range. This tool does not remove entire rows or records, just the data values in the selected column.
Menu Options
- Input Column: Select from this drop-down list the name of the column in the datasheet that contains the data values to be removed or replaced.
- Low Stop: Insert a check in this box to remove/replace low values from the column.
- Stop Value: Type in the real number value below which values will be removed. You can activate either or both high and low filters.
- Replacement Text: If you would like to replace the filtered values with another numeric value or text string, click here and type that into this prompt. This provides a means for flagging special samples (e.g. "Below Detection") or setting the cell values to the cutoff values, in addition to simply leaving cells blank.
- High Stop: Insert a check in this box to remove high values from the column.
- Stop Value: Type in the real number value above which values will be removed.
- Replacement Text: If you would like to replace the filtered values with another numeric value or text string, click here and type that into this prompt.
Step-by-Step Summary
- Access the RockWorks Utilities program tab.
- Open the datasheet to be manipulated.
- Click on the Columns menu above the datasheet, and select the Filter option.
- Enter the requested menu settings, described above.
- Click the Process button to proceed.
The program will scan the values in the indicated Input Column, compare them to the filter range specified, and remove those values that fall below the low value and/or above the defined high. Only cells will be cleared; no rows will be removed.
Back to Editing the Datasheet
RockWare home page