Apply Regular Expression

This action applies regular expression. Enter regex inside slashes (/example/). Use /g at the end for all occurrences (/example/g).

Method 'replace'

This method searches for a match and replaces its first occurrence with the entered replacement value.

To replace all occurrences, use /g (/example/g).

Example: Replace all commas with empty space

Note: The value that you want to replace is correctly entered inside two slashes. The letter 'g' after the closing slash means that all occurrences should be replaced.

Value to replace with is left empty because we want to replace commas with nothing.

Method 'exec'

This method searches for a match and updates the value with the first found match.

Example: Imagine you want to get ids from a list of Google Sheet links. This regex /\/([\w-_]{15,})\/(.*?gid=(\d+))?/ will search for a Google Sheet id inside a Google Sheets link.

Assume this value is currently in the column:

This is the needed set-up:

This is the result:

FAQ

I'm not a developer, can I still use regex?

Absolutely! Regex is simply a sequence of characters that specifies a match pattern in text. Anyone can use it. There are many reference guides on the internet to learn more. Here is one example: Regex reference guide.