Data Text Formatter
Data Text Formatter applies formatting changes to the texts in your records: lowercase or uppercase, removing accents, trimming extra spaces, or replacing some characters with others. You can apply it to every text field or only to the fields you choose, including fields nested inside others.
It is useful to leave your data clean and consistent before comparing it, searching it or sending it to another system.
When to use it
- Standardise city or product names written in different ways (“Málaga”, “MALAGA”, ” malaga ”).
- Prepare codes or references without spaces or accents for a business system.
- Create readable identifiers from a title, for example
summer-offer. - Normalise emails or user names to lowercase before looking them up in your CRM.
Configuration
| Field | What it does |
|---|---|
| Data | The records or messages you want to transform. |
| Target Keys | Fields to transform, separated by commas (for example name, city). Leave it empty to transform every text. |
| Case Conversion | Changes letter case: None (no change, default), lowercase, UPPERCASE or Capitalize (first letter of each word in capitals). |
| Remove Accents | Removes accents and similar marks (é→e, ñ→n, ü→u). Enabled by default. |
| Replace Spaces | Turns on space replacement. Off by default. |
| Replace Spaces With | Shown when Replace Spaces is on. Character that replaces each space. Default: -. |
| Replace Characters | Turns on custom character replacements. Off by default. |
| Number of Replacements | Shown when Replace Characters is on. How many replacements you want to define, from 1 to 5. |
| Find / Replace with | One pair per replacement: the text to look for and the text that replaces it. Leave Replace with empty to delete what is found. |
Advanced options
| Field | What it does |
|---|---|
| Trim Whitespace | Removes spaces at the start and end of each text. Enabled by default. |
Changes are applied in this order: extra spaces, accents, letter case, space replacement and, finally, your own replacements.
Output
The Formatted Data output returns the same records with the transformed texts. Fields that are not text, such as numbers or dates, are left as they are.
Example
You want to build each product’s web address from its name.
- Connect the catalogue to Data and enter
namein Target Keys. - Choose
lowercasein Case Conversion and keep Remove Accents on. - Turn on Replace Spaces with
-. - “Camiseta Algodón Azul” becomes
camiseta-algodon-azul.