Find and replace

Find and replace

Applies a set of find/replace rules to the incoming data

Find it, replace it, move on

This step works similar to most find and replace functions out there. The base functionality is that it looks for whatever you typed in, and allows you to replace it when found. That can be applied to all columns, or one specifically.

By default, the step ignores casing, but you can enforce it by clicking the icon in the Find field.

Using multiple Find Replace rules

You'll notice that you can create as many Find Replace rules as you'd like in the step - each represented by a card.

The rules are applied to the entire dataset/column in top-down order. So the first rule will be applied to every row, and the replacements will be made, and then the next rule will be applied.

This means that if you replace a value with something that will be picked up by a subsequent rule, additional updates will be made to that field.

Try Parabola for free