Text Transform

Tidy a text column in one click. Change the case, or cut off stray spaces.

Pick a column, pick a transform

  1. Type text transform in the Search transforms box, in the Pipeline panel.
  2. Select Text Transform in the results.
  3. Open Select column and pick a column. Say you pick product_name in a catalogue file.
  4. Open the Transform dropdown and choose an option from the table below.
  5. Read the Preview that appears.
  6. Click Apply.

The eight options

OptionResultExample
uppercaseEvery letter becomes a capital.Red Mug to RED MUG
lowercaseEvery letter becomes small.Red Mug to red mug
trimCuts spaces off both ends.  Red Mug   to Red Mug
ltrimCuts spaces off the left end only.  Red Mug to Red Mug
rtrimCuts spaces off the right end only.Red Mug   to Red Mug
capitalizeCapital first letter, small letters after it.RED MUG to Red mug
reverseTurns the text back to front.Red Mug to guM deR
lengthCounts the characters and writes the count.Red Mug to 7

Two options need care. capitalize works on the whole cell, not on each word. length drops the text and leaves a count, so the column turns into a number column.

Read the preview first

A Preview block appears once you choose a column and a transform. It shows up to three real values from your data. Each line shows the old value, an arrow, and the new value. Change the option to refresh the preview.

The column is replaced

This step writes the result back into the same column. It does not add a column. Run Copy Columns first if you want to keep the original text.

The column keeps its position in the grid.

Treat only some rows

Click Add Condition below the preview. Build a test such as brand is Acme, then click Apply Condition. Rows that fail the test keep their old text.

For SQL users

A trim on one column runs as:

SELECT "sku", "price", TRIM("product_name") AS "product_name" FROM data
Try Text Transform with sample data →

Related Operations