Finding and replacing values

In Wrangler, you can find and replace values in any type of column. You can select to replace exact matches and whether to ignore case.

To replace values in a column, follow these steps:

1. Click the drop-down button next to the column name.

2. Click Find and replace.

3. In the Find box, enter the value you want to replace. You can specify to replace only exact matches and to ignore case.

4. In the Replace with box, enter the replacement value.

5. Click Replace All.

Wrangler replaces all values in the column and adds the find-and-replace directive to the recipe. When you run the data pipeline, the transformation will be applied to all values in the column.

For example, you have a column of Names. You want to replace the salutation Miss. with Ms. To do this, from the drop-down menu, select Find and replace. In the Find box, enter Miss. In the Replace with box, enter Ms.. Click Replace All. Wrangler replaces all instances of Miss. with Ms.:

Open

Wrangler adds the directive find-and-replace Name s/Miss./Ms./g to the recipe.