Reference
Find & replace node

Please contact your Customer Success Manager to get access to this node. This is a dedicated feature that is not generally available.

What is find & replace’?

Find & Replace is a function that searches for a specific word, phrase, or symbol in a text field and replaces it with a new value of choice. It’s commonly used to clean up data and correct formatting inconsistencies. This node is case sensitive and utilises regular expression (RegEx) capabilities. 

Usage scenarios

A business wants to ensure phone numbers are formatted consistently by removing spaces or dashes to work in a query. The Find & Replace node scans the inputted data, in this case, using a regex pattern [ -]. This finds phone numbers such as 141-555 52671 and removes the dashes/spaces to create the output of 14155552671.

Node configuration

Select replace mode

Replace first occurrence: Within the text of the merge field, this will find the first occurrence of an instance within the text of the merge field. It will replace it with the inputted content in the “Replace” field.

Replace all occurrences: This will find all occurrences of an instance and replace it with the inputed content in the “Replace” field.

Select field to search
This is the merge field which you want to modify. 

Find
Type in the case-sensitive text for the system to find within the supplied data. Additionally, you can insert a merge field to find within another field of your choice.

Replace
Type in the case-sensitive text for the system to replace within the supplied data source. Additionally, you can insert a merge field to replace an instance of your choice.