Task
Product descriptions arrive in different casing: some start with a lowercase letter, and some are fully uppercase. The export needs a normal sentence-style description.
Short answer
In the description column, add two transformations in sequence: Lowercase, then Capitalize first letter.
How to Do It in Eofferix
- Open the settings of the
descriptioncolumn.
The animation shows how to open the description settings. - In Transformations, add the Lowercase rule.
The first rule lowercases accidental uppercase text in the whole value. - Add the Capitalize first letter rule below it.
The second rule capitalizes only the first letter of the final description. - Save the column settings and continue to export.
Before / After
Before
source data| sku | description |
|---|---|
| SKU-1001 | PRODUCT DESCRIPTION FOR CATALOG |
After
result| sku | description |
|---|---|
| SKU-1001 | Product description for catalog |