Filtering to locate specific information

Filtering lets you locate specific information within a dataset:

  • You can search all text columns for specific text. The filter field at the top of the Data Viewer lets you do this.

  • You can search specific columns for text, dates, and numbers. To do this, click the column header, or the filter button displayed when you move the mouse pointer over the column header. Depending on the field type, the appropriate filter options are displayed above. See Filtering by date or number below.

When you apply a filter, you’ll see the number of matching rows displayed above the table.

To remove the filter, click the x beside the filter name.

Filtering by date or number

As shown above, you can search specific columns for dates or numbers, depending on the field type. When you click the filter button associated with a date or numeric field, the corresponding filter tools are displayed at the top of the screen. Make sure the column you’re trying to search is defined as a date or number field.

To filter by date or date range:

  1. Click the filter button at the top of a date column or beside the field description at the left of the screen.

  2. In the Min field, enter the start date. You can type in the date using the format shown, or you can click the down-arrow and select the date from a calendar.

  3. In the Max field, enter the end date. To search for a specific date, enter the same date in both fields.
  4. Click Apply.

To search by number or numeric range:

  1. Click the filter button at the top of a numeric column or beside the field description at the left of the screen.

  2. In the Min field, enter the minimum value.
  3. In the Max field, enter the maximum value. To search for a specific number, enter the same number in both fields.
  4. Click Apply.

Filtering and searching on a cell value

You can filter the table data based on the value in a specific cell. To do this, right-click the cell and choose Filter field by. This searches within the column for other instances of the cell value and displays the matching rows.

Use the right-click > Search for option to launch a global search for instances of the cell value. This option takes you to the main search results screen (see Searching for information).

Advanced filtering

When searching individual text fields or all text fields, you can use the following special operators in the “Enter keywords” field:

Operator Description Example
|| Returns rows that include either of the specified terms (OR) federal || reserve
&& Returns rows that include both of the specified terms (AND)1 federal && reserve
- Returns rows that do not include the specified term (NOT) -enigma
* Wildcard sul*ur matches “sulphur” and “sulfur”
~n Fuzzy matching, where n is an integer specifying the degree of closeness color~1 matches “color” and “colour”

1 AND is the default operator, so federal reserve is the same as federal && reserve.