Reference · Visual workspace
Trim whitespace in Visual workspace
Remove a declared set of characters from both ends of a text value without touching the inside.
When to use it
Keys, codes and categories padded with spaces, tabs or line breaks, before any comparison or lookup.
How
Add step → Text → Trim. Choose the column and the character set: ASCII whitespace, spaces only, or all Unicode whitespace.
Trim customer_code (ASCII whitespace)
- The step ledger shows how many cells changed.
- Trim never changes the column type, so leading zeros survive.
Pitfalls
- Relying on the tool's default definition of whitespace.
- Casting identifiers to numbers to drop padding.
- Trimming only one side.
Lesson: Trim the right characters, and only those
Practise it: Clean an order-line export