Reshape and enrich records
Normalize
Cleans up emails, phone numbers, countries and currency codes so records from different systems match.
Nodes › DataOpen in Neblex
- Good for
- Clean, matchable data
- Role
- Works on the records in a flow
- Find it in
- Nodes › Data
When to use it
- Records from several systems should match on email, phone or country.
- Phone numbers should be stored in one international format.
- Values that cannot be cleaned should be tagged or routed for review.
Reach for something else when
Edit fieldsWhen you need general text changes rather than these rules.Validate RecordsWhen records only need checking, not repairing.
Example
Normalize phone numbers to E.164 and countries to two-letter codes before loading contacts into the CRM.
How it works
- Settings
- Rules, each a Field and what to do with it: Email addresses (trimmed, the domain in lower case; the part before @ keeps its case, as mail servers may treat it so), Phone numbers (to E.164 such as
+15551234567; a number without a country code is read in the rule's Region), Country (any name, in English, German or Spanish, or a two- or three-letter or numeric code, to its two-letter code), Currency code (a symbol or name to its three-letter code), Trim and collapse spaces, Unicode (NFC), Title case, Digits only. Mode: Repair [default], Tag or Route. - Output
- Repair writes every value it can normalize and leaves the rest as they were. Tag adds
_invalid, the fields that could not be normalized. Route adds_normalized(true or false) as well, and the node shows Valid and Invalid outputs.
Add it to a flow
- Open the flow from Build › Workflows.
- Open Nodes and find Normalize under Data, or search for it. Click it or drag it onto the canvas.
- Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
- Run the flow and click the step to see the records it received and produced.
More in Reshape and enrich records
Map fields and Transform itemsBuilds a new record field by field in the Transform Studio, with a live preview.Nodes › TransformEdit fieldsApplies a list of set, rename and remove rules to every record in one step.Nodes › TransformSet fieldsAdds or overwrites some fields and removes others; everything else passes through.Nodes › TransformRename fieldsRenames fields, one rename per line.Nodes › TransformLookupAdds a matching record from an earlier step to each record, without a database.Nodes › TransformData tableReads and writes one of your built-in data tables, with a visual query editor.Nodes › Transform