RockWorks | Datasheet | Filter | Lo/Hi
Use this Datasheet program to remove or replace numeric values that fall below and/or above a specified value range. This does not remove entire rows or records, just the data values from the cells in the selected column.
- Data 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.
- Options
- Low-Stop / High Pass Filter: Insert a check in this box to remove/replace ("stop") low values from the column.
- Cutoff Value: Type in the real number value below which values will be removed or replaced. 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 / Low-Pass Filter: Insert a check in this box to remove/replace ("stop") high values from the column.
- Cutoff Value: Type in the real number value above which values will be removed or replaced.
- 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.
- Access the RockWorks Datasheet program tab.
- Open the datasheet to be manipulated.
- Click on the Filter menu above the datasheet, and select the Lo/Hi option.
- Enter the requested program settings, described above.
- Click the Continue 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