Reshape and enrich records
Edit text
Trims, changes case, finds and replaces, or measures text in a field.
Nodes › TransformOpen in Neblex
- Good for
- Cleaning text before use
- Role
- Works on the records in a flow
- Find it in
- Nodes › Transform
When to use it
- Inputs need cleaning before they are matched, compared or stored.
Reach for something else when
Example
Trim and lowercase email addresses before removing duplicates.
How it works
- Settings
- Operation: Trim whitespace [default], UPPERCASE, lowercase, Find & replace, Length; Field; Find / Replace with; Into field [
text].
Add it to a flow
- Open the flow from Build › Workflows.
- Open Nodes and find Edit text under Transform, 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