Skip to main content

How to Find Pattern Matches in a table


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

  1. Select the table column you want to filter
  2. Enter a regex pattern
  3. 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.


Tip
Resource
A great online resource for creating and testing Regular Expressions is https://regex101.com/. Here you can insert your strings and test the expression to ensure it is correct and working.

 

Was this article helpful?
0 out of 0 found this helpful

Still stuck?

Send us your inbox name and a sample email.

Submit a request