As you can deduce from the previous table, if you need to search and replace some text, one option is to use the Replace in string step. In the simplest scenario, you look for fixed text and replace it with other fixed text. However, this step supports more elaborate searches and replacements through the use of regular expressions and group references. Let's explain this with some examples:
- Create a new Transformation.
- Create a dataset with zip codes, similar to the one created in the previous example.
- At the end of the flow, add a Replace ...