Overview
The Find Pattern Matches filter lets you extract specific values from a table column using a pattern.
This is useful when you want to:
- Keep only values that match a specific format
- Extract structured data (like IDs or phone numbers)
- Remove unwanted text from a column
How It Works
The filter applies a regular expression (regex) to each cell in a selected column and returns only the matching content.
How to Use It
- Select the table column you want to filter
- Enter a regex pattern
- Wrap the pattern in forward slashes:
/your-pattern/
Examples
Match a 7 to 9 digit number
/\d{7,9}/Match a code like AB-1234567
/[A-Z]{2}-\d{7}/Extract any number
/\d+/
Tips
- Start with a simple pattern and refine it
- Be specific to avoid matching unwanted data
- Test your regex before applying it
Summary
Use the
Find Pattern Matches filter
to clean and standardize table data by extracting only the values that match
a defined pattern.
|