Split, merge and extract text
Three small columns reshape text without a key: Split cell breaks one column into several, Merge columns joins several into one, and Get emails from text pulls addresses out of free text.
Split cell
Choose Enrichment → Split cell, pick the source column, then choose how to split it:
| Operator | What it does |
|---|---|
| Split by delimiter | Cuts at a character you type in Delimiter (a space by default). Output: First part + rest, or All parts (up to 10 columns). |
| Split by regex | Cuts wherever a regular expression matches, with the same two outputs. |
| Extract by regex (capture groups) | One new column for each capture group in your expression. |
| First N characters / rest | The first N characters (10 by default), and the rest. |
| Before index / after index | Cuts at a 0-based position. |
| Trim whitespace | Collapses runs of spaces to one. No new columns. |
The first part is written into the column you added, and the other parts go into new columns next to it, named Part 2, Part 3 and so on. Your original column is never changed. There is no separate “split on whitespace” choice; use Split by delimiter with a space. If your regular expression is not valid, the cell keeps the original text and the extra part is empty.
Merge columns
- Choose Enrichment → Merge columns.
- Under Source columns (order matters), add the columns in the order you want them joined, for example First name then Last name.
- Set the Separator, for example a space or a comma. You can type
\nfor a new line and\tfor a tab. Leave it empty to join with nothing in between. - Keep Skip empty cells ticked (it is by default) so a missing value does not leave a double separator.
Get emails from text
Choose Enrichment → Get emails from text, pick the Source column that holds free text, and choose Extract: First email only, or All emails (comma-separated). The addresses go into an Email column. A row with no address shows No email found. Use it on scraped page text or a notes column.