The Regex tool is a super-powered search-and-match tool, like “Find” in a text editor but much more flexible. It’s a pattern-matching language that lets you describe what you’re looking for rather than searching for exact text. To exemplify, you could use (\d+) to extract all the numbers from a column. Check out the examples at the end of the page for additional examples. Regex (short for Regular Expressions) utilies a special language to extract certain elements of a text/string column.

Regex Cheatsheet

​
Configuration

The Regex tool consists of three required input.
1

Select Column

Select the column you want to extract text from with Regex
2

Input Column Name

The Regex tool will create a new column. Use this input to name it.
3

Input Regex

Input your regex statement. You can only extract one regex group at the time. Remeber to add parentheses around your marked group.

​
When To Use

The Regex tool is helpful when you have suboptimal data quality and need to standardize the data:
  • You have different date formats (e.g. US, European and ISO) and would like to standardize these
  • Your HR systems use different time formats (24-hour clock, AM/PM, etc.) and you need to standardize these
  • You need to extract social media handles or hashtags from customer feedback or mentions
  • Extract and standarize ratings from customer reviews

​
Examples

I want to extract the numbers from a amount column that contains currenciesWe use this regex statement (\d+(?:\.\d+)?). To translate:
  • \d+ is looing for one or more digits
  • ?: is a non-capturing group which in short means that we don’t want these mathes to be stored separately (in our example the decimals are part of the number, hence why we don’t want them stored separately)
  • \. is looking for a . (dot)
  • \d+ is looing for one or more digits
I want to extract the domain from my customer emails to get their companyWe use this regex statement @(\w+).. To translate, before what we want to extract there’s a @ and our extract group finishes before the . (dot)
I want to standardize my product ratingsWe use the following regex:
  • Tool ID 3: (\d+)\s*
  • Tool ID 4: \s*(?:/|out of)\s*(\d+)