Extract Text
Extract text patterns from a column
What It Does
Extract Text pulls out parts of text using various methods: by position, before/after a delimiter, between delimiters, or with regex patterns.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Extract Text". It's in the Transform group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column to extract from |
Method | Select | Yes | position, starts_with, ends_with, before_delimiter, after_delimiter, between_delimiters, contains_number, regex |
SQL generated under the hood
SELECT *, SUBSTRING(email, 1, POSITION('@' IN email) - 1) AS username FROM dataRelated Operations
- Update Values - Update column values with expression
- Find & Replace - Search and replace values in a column
- Text Transform - Transform text: uppercase, lowercase, trim