This tab allows the user to filter the data that has been input, selecting some rows to appear and others to be suppressed. Filtering is accomplished by using the following buttons that appear on this tab.

Field Name

This is a drop down list of all the columns in your data. Select the next field name on which you wish to filter.

Comparison Operator

This is a drop down list. Pick the operator that you want to use to compare your selected field to the following value. The following operators are available.

equals
greater than
greater than or equal to
less than
less than or equal to
not equal to
contains
does not contain
starts with
does not start with
ends with
does not end with

Comparison Value

This is the value to which the selected field will be compared. Only rows that satisfy this comparison will be visible after the filtering operation. You may type in a desired value, or select from the drop down list. The drop down list will consist of all the values found in this field within your data.

Add

Pressing this button will add the field, operator and value currently specified to the current filter parameters being built. The filter parameters added will appear in the text area shown below on this tab. After pressing the Add button, the user may go back and specify additional fields to be used in the filtering criteria.

Clear

Pressing this button will clear the filter parameters being built, so that you can start over.

Set

Once your desired filter parameters have been completely built, by pressing the Add button one or more times, you must press the Set button to cause your parameters to be applied to the data you are currently processing.

And/Or

If you specify more than one filter parameter, then you may specify whether all of them must be true (and) or only any one of them must be true (or) in order to satisfy the filtering criteria. This choice applies to the entire set of criteria, so this need only be selected once before pressing the Set button.

Continue with Output Tab.

http://www.powersurgepub.com/ | filter.html | Revised: 1/20/12