Replace in String
Description
Replace in String searches for text within string fields and replaces all occurrences with a specified value. Use this step for data cleaning and standardization — for example, correcting common misspellings, removing unwanted characters, reformatting phone numbers, or normalizing category codes. It supports both simple literal matching and regular expressions with group references, making it flexible enough for both basic text swaps and complex pattern-based transformations.
Configurations
| Field Name | Description |
|---|---|
| Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| In Stream field | Select the in stream field where search and replace is to be done. |
| Out Stream field | Select the out stream field where the new string value is put. |
| Use RegEx | Is your search string a regular expression. Select Y/N |
| Search | Enter the search string. |
| Replace with | Replace the search string with the replace string. |
| Set empty string? | Set the string to null(Y/N). |
| Replace with field | Select a field use to replace the Out Stream field. |
| Whole Word | Is the search and replace field a whole word. Select Y/N |
| Case sensitive | Is the search and replace field case sensitive. Select Y/N |