Run Regex extracts part of a value using a pattern. The tool is marked Free.
How do I add it?
Click Add column, then open the Tools tab.
Under Transform, click Run Regex ("Extract or test a pattern").
In Data to evaluate, type
@or/and pick the column to read.In Regex Pattern (Advanced), type the pattern. The hint shows
(?<email>[\w.-]+@[\w.-]+\.[A-Za-z]{2,}).Click Add column and run 3 rows (the number is your row count).
Until a pattern is entered the footer says "Regex pattern is required."
Can the app write the pattern?
Yes. In the box at the top ("Describe what you want to extract in plain text"), say what you want, for example email addresses or phone numbers, and click Generate RegEx.
Example
With a column holding acme.example, globex.example and initech.example, the pattern (?<site>[a-z]+)\.example returned acme, globex and initech in a new column called Run Regex.
Good to know
The tool does not spend from your wallet.
Run Regex computes on its own whether the table's Auto-run is Off or On. Its header shows a check icon.
The Edit column panel of a Run Regex column has only a Configuration section and a Save button. It has no Run Settings, no Auto-run switch and no run condition.