Cleaning
Trim Whitespace
Removes leading and trailing whitespace from the values in one column.
When to use it
Use it right after an import when stray spaces from a spreadsheet or CSV would break joins, grouping or duplicate detection.
In a pipeline
File InputTrim WhitespaceRemove Duplicates
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | — |
Example
Clean up imported customer names
- Column=Customer
| Order | Customer |
|---|---|
| A-1 | Acme Ltd |
| A-2 | Bright Co |
| Order | Customer |
|---|---|
| A-1 | Acme Ltd |
| A-2 | Bright Co |
Spaces at the ends are removed; the space inside Acme Ltd is kept.
Worth knowing
- Only the ends are trimmed; use Regex Replace to collapse repeated spaces inside a value.
- One column per node, so add several nodes when a file needs more than one cleaned.
- Null and missing cells become empty text, which Fill Null Values can then replace.