Find & Replace
Search and replace values in a column
What It Does
Find & Replace searches for text in a column and replaces it with new text. Supports multiple find/replace pairs.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Find & Replace". It's in the Transform group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column to search in |
Find/Replace pairs | List | Yes | Text to find and its replacement |
SQL generated under the hood
SELECT *, REPLACE(status, 'pending', 'awaiting') AS status FROM dataRelated Operations
- Update Values - Update column values with expression
- Text Transform - Transform text: uppercase, lowercase, trim
- Math - Arithmetic operations on columns