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:
Click the search input in your chosen filter
Select the "has" operator
Type your search term or select from the autocomplete options
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 numbersopen|closed
- Matches either "open" or "closed"
Anchored Patterns:
^sample
- Matches text starting with "sample".fa$
- Matches text ending with ".fa"
Regular expressions match any part of the text by default. Use ^ and $ to match the start and end of the text.
Excluding Values
Use the "not" operator to exclude specific values:
Select the "not" operator
Enter the text you want to exclude
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?