> For the complete documentation index, see [llms.txt](https://docs.omics.ai/products/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.omics.ai/products/explorer/filtering-data-in-tables/strings.md).

# 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:**

* <mark style="color:orange;">`ID-.*open`</mark> - Matches "ID-" followed by any text containing "open"
* <mark style="color:orange;">`ID-[0-9]+`</mark> - Matches "ID-" followed by one or more numbers
* <mark style="color:orange;">`open|closed`</mark> - Matches either "open" or "closed"

**Anchored Patterns:**

* <mark style="color:orange;">`^sample`</mark> - Matches text starting with "sample"
* <mark style="color:orange;">`.fa$`</mark> - Matches text ending with ".fa"

{% hint style="info" %}
Regular expressions match any part of the text by default. Use ^ and $ to match the start and end of the text.
{% endhint %}

## 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.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.omics.ai/products/explorer/filtering-data-in-tables/strings.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
