Task
Product names in the table use mixed casing: some are lowercase and some are fully uppercase. The result should have every word starting with an uppercase letter.
Short answer
In the name column, add two transformations in sequence: Lowercase, then Capitalize each word.
How to Do It in Eofferix
- Open the settings of the
namecolumn.
The animation shows how to open the name settings. - Add the first rule: Lowercase.
The first rule lowercases the name so OFFICE CHAIR does not remain uppercase. - Below it, add Capitalize each word.
The second rule capitalizes the first letter of every word. - Save the column settings and continue to export.
Before / After
Before
source data| sku | name |
|---|---|
| SKU-100 | OFFICE CHAIR |
| SKU-101 | desk lamp |
After
result| sku | name |
|---|---|
| SKU-100 | Office Chair |
| SKU-101 | Desk Lamp |