Text Transform
Transform text: uppercase, lowercase, trim
What It Does
Text Transform applies a text transformation to a column: convert to uppercase, lowercase, trim whitespace, capitalize, reverse, or get string length.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "Text Transform". It's in the Transform group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column to transform |
Transform | Select | Yes | uppercase, lowercase, trim, ltrim, rtrim, capitalize, reverse, length |
SQL generated under the hood
SELECT *, UPPER(name) AS name FROM dataRelated Operations
- Update Values - Update column values with expression
- Find & Replace - Search and replace values in a column
- Math - Arithmetic operations on columns