Filtering data

Filtering to locate specific information

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

Tip: To search a text column for empty cells, enter -* as the search string.

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:

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

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.

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

Press Enter. You may need to click one of the dates first.

To search by number or numeric range:

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

In the Min field, enter the minimum value.

In the Max field, enter the maximum value. To search for a specific number, enter the same number in both fields.

Press Enter. You may need to click one of the values first.

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.

Enigma, the Enigma logo, Assembly, Concourse and Enigma Public are trademarks of Enigma Technologies, Inc. and may not be used without the express prior written permission of Enigma Technologies, Inc. This documentation is provided for guidance and informational purposes only and does not modify, add to, or replace any provisions of any agreement you may have with Enigma Technologies, Inc.