Wrangler は列の値を置き換え、find-and-replace ディレクティブをレシピに追加します。データ パイプラインを実行すると、Cloud Data Fusion は列内の各値に変換を適用します。たとえば、Name という名前の列で、前の手順を使用して文字列 Doctor を Dr. に置き換えます。Wrangler は、ディレクティブ find-and-replace Name s/Doctor/Dr./g をレシピに追加します。
[[["わかりやすい","easyToUnderstand","thumb-up"],["問題の解決に役立った","solvedMyProblem","thumb-up"],["その他","otherUp","thumb-up"]],[["わかりにくい","hardToUnderstand","thumb-down"],["情報またはサンプルコードが不正確","incorrectInformationOrSampleCode","thumb-down"],["必要な情報 / サンプルがない","missingTheInformationSamplesINeed","thumb-down"],["翻訳に関する問題","translationIssue","thumb-down"],["その他","otherDown","thumb-down"]],["最終更新日 2025-09-04 UTC。"],[[["\u003cp\u003eThis page provides instructions on how to use the "Find and replace" feature within the Wrangler workspace of Cloud Data Fusion Studio.\u003c/p\u003e\n"],["\u003cp\u003eWrangler enables users to find and replace specific values within columns, regardless of the data type.\u003c/p\u003e\n"],["\u003cp\u003eThe process involves navigating to the desired column, selecting "Find and replace," specifying the values to find and replace, and then executing the replacement.\u003c/p\u003e\n"],["\u003cp\u003eUpon completing the replacement, Wrangler automatically adds a \u003ccode\u003efind-and-replace\u003c/code\u003e directive to the recipe, which is then applied during the data pipeline's execution.\u003c/p\u003e\n"]]],[],null,["# Find and replace data\n\nThis page explains how to find and replace when you prepare data in the Wrangler\nworkspace of the Cloud Data Fusion Studio. In Wrangler, you can find and replace\nvalues in columns of any data type.\n\nTo find and replace values in a column, follow these steps:\n\n1. [Go to Wrangler workspace in Cloud Data Fusion](/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).\n2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.\n3. Select **Find and replace**.\n4. Optional: choose to replace only exact matches and to ignore letter case.\n5. In the **Find** field, enter the value to replace.\n6. In the **Replace** field, enter the replacement value.\n7. Click **Replace all**.\n\nWrangler replaces the values in the column and adds the `find-and-replace`\ndirective to the recipe. When you run the data pipeline, Cloud Data Fusion\napplies the transformation to each value in the column. For example, in a column\ncalled `Name`, you replace the string `Doctor` with `Dr.` using the preceding\nsteps. Wrangler adds the directive `find-and-replace Name s/Doctor/Dr./g` to the\nrecipe.\n\nWhat's next\n-----------\n\n- Learn more about [Wrangler directives](/data-fusion/docs/concepts/wrangler-overview#apply_directives)."]]
