데이터 탭에서 열 이름으로 이동하고 arrow_drop_down 펼치기 화살표를 클릭합니다.
찾기 및 바꾸기를 선택합니다.
선택사항: 일치검색만 바꾸고 대소문자가 무시되도록 선택합니다.
찾기 필드에 바꿀 값을 입력합니다.
바꾸기 필드에 대체 값을 입력합니다.
모두 바꾸기를 클릭합니다.
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)."]]
