Find and replace

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.
  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