Task
description contains repeated spaces, line breaks, and HTML spaces such as . The result should be clean text without joined words.
Short answer
For description, replace the substring with a normal space, then add Collapse spaces and trim the value.
How to do it in Eofferix
Open the settings of the
descriptioncolumn.
The outline shows where to open the description settings. In
Transformations, add: conditionContains substring, value , actionReplace substring; put one normal space in the result field. Then addCollapse spacesand trim edges.
The first rule replaces with a normal space, the second collapses repeated spaces, and the third trims edges.Save the template and run the transformation on the final step.
Before / after
Before
source data| sku | description |
|---|---|
| SKU-100 | Desk lamp black |
| SKU-200 | Office chair gray |
After
result| sku | description |
|---|---|
| SKU-100 | Desk lamp black |
| SKU-200 | Office chair gray |