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:
On the Data tab, go to a column name and click the
arrow_drop_down
expander arrow.
Select Find and replace.
Optional: choose to replace only exact matches and to ignore letter case.
In the Find field, enter the value to replace.
In the Replace field, enter the replacement value.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-04-12 UTC."],[[["This page provides instructions on how to use the \"Find and replace\" feature within the Wrangler workspace of Cloud Data Fusion Studio."],["Wrangler enables users to find and replace specific values within columns, regardless of the data type."],["The process involves navigating to the desired column, selecting \"Find and replace,\" specifying the values to find and replace, and then executing the replacement."],["Upon completing the replacement, Wrangler automatically adds a `find-and-replace` directive to the recipe, which is then applied during the data pipeline's execution."]]],[]]
