Transforms: Cleaning Values Step by Step

Transforms clean and reshape a value on its way to the output. Chain as many as you need on any field - they run top to bottom, each one acting on the result of the last.

How the pipeline works

Open a field and add transforms in order. The value flows through each step:

t-shirt → strip → t-shirt → Title Case → T-Shirt → prepend → Men's T-Shirt

Available transforms

• lowercase / UPPERCASE / Title Case - change text case
• strip - remove leading and trailing whitespace
• number - keep only digits and decimal separators (great for prices with currency symbols)
• Format - render a number as a currency or fixed-decimal string
• prepend / append - add fixed text before or after (e.g. prepend https: to protocol-relative URLs, append USD)
• replace - find and replace text, including regex-driven find-and-replace
• truncate - cap the value at N characters (useful for title length limits)

Transform presets

Save a multi-step chain you use often as a preset, then apply the whole pipeline to another field in one click - no rebuilding it step by step.

Order matters

Because each step feeds the next, sequence changes the result: strip before Title Case, format a number before appending a unit. The Live Preview shows the output after every step, so you can see exactly where a value changes.