Text
Change Case
Rewrites the values of one column as upper case, lower case or title case.
When to use it
Use it to normalise names, codes or statuses before a join, a grouping or a duplicate check that compares text exactly.
In a pipeline
File InputChange CaseExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | — |
| Case Type | select | Yes | upper |
Example
Title case for customer names
- Column=Customer
- Case Type=Title Case
| Order | Customer |
|---|---|
| C-1 | ACME ltd |
| C-2 | mia OSBORN |
| Order | Customer |
|---|---|
| C-1 | Acme Ltd |
| C-2 | Mia Osborn |
Each word keeps its first letter capitalised and the rest is lowered.
Worth knowing
- Title case lowers the rest of every word, so O'Neill becomes O'neill and USA becomes Usa.
- Words are split on whitespace only, so north-west becomes North-west.
- Pair it with Remove Duplicates when the same value appears with different casing.