This page explains how to find and replace when you prepare data in the Wrangler
workspace of the Cloud Data Fusion Studio. In Wrangler, you can find and replace
values in columns of any data type.

To find and replace values in a column, follow these steps:

1. [Go to Wrangler workspace in Cloud Data Fusion](https://docs.cloud.google.com/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).
2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.
3. Select **Find and replace**.
4. Optional: choose to replace only exact matches and to ignore letter case.
5. In the **Find** field, enter the value to replace.
6. In the **Replace** field, enter the replacement value.
7. Click **Replace all**.

Wrangler replaces the values in the column and adds the `find-and-replace`
directive to the recipe. When you run the data pipeline, Cloud Data Fusion
applies the transformation to each value in the column. For example, in a column
called `Name`, you replace the string `Doctor` with `Dr.` using the preceding
steps. Wrangler adds the directive `find-and-replace Name s/Doctor/Dr./g` to the
recipe.

## What's next

- Learn more about [Wrangler directives](https://docs.cloud.google.com/data-fusion/docs/concepts/wrangler-overview#apply_directives).