Strings

How to use filter operators for facets containing values of string datatype.

Filter string columns in your data using a variety of operators to find exactly what you need. Each string filter provides different ways to match and filter text data.

Available String Operators

Explorer provides several operators for filtering string data:

  • has - Shows values containing a specific substring

  • regex - Filters using regular expression patterns

  • not - Excludes values containing a specific substring

  • empty - Shows only empty values

  • not empty - Shows only non-empty values

Basic Text Filtering

To filter using basic text matching:

  1. Click the search input in your chosen filter

  2. Select the "has" operator

  3. Type your search term or select from the autocomplete options

  4. Click "Apply" to activate the filter

Advanced Pattern Matching

The regex operator allows powerful pattern matching using regular expressions. Here are some common patterns:

Basic Patterns:

  • ID-.*open - Matches "ID-" followed by any text containing "open"

  • ID-[0-9]+ - Matches "ID-" followed by one or more numbers

  • open|closed - Matches either "open" or "closed"

Anchored Patterns:

  • ^sample - Matches text starting with "sample"

  • .fa$ - Matches text ending with ".fa"

Excluding Values

Use the "not" operator to exclude specific values:

  1. Select the "not" operator

  2. Enter the text you want to exclude

  3. Click "Apply"

Empty Value Filtering

Quickly find or exclude empty values using the "empty" and "not empty" operators. These filters apply immediately when selected.

Last updated

Was this helpful?