Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Halaman ini menjelaskan cara menemukan dan mengganti saat Anda menyiapkan data di ruang kerja Wrangler di Cloud Data Fusion Studio. Di Wrangler, Anda dapat menemukan dan mengganti
nilai di kolom dari jenis data apa pun.
Untuk menemukan dan mengganti nilai dalam kolom, ikuti langkah-langkah berikut:
Di tab Data, buka nama kolom, lalu klik panah peluas arrow_drop_down.
Pilih Cari dan ganti.
Opsional: pilih untuk hanya mengganti kecocokan persis dan mengabaikan huruf besar/kecil.
Di kolom Temukan, masukkan nilai yang akan diganti.
Di kolom Replace, masukkan nilai pengganti.
Klik Ganti semua.
Wrangler mengganti nilai di kolom dan menambahkan perintah find-and-replace
ke resep. Saat Anda menjalankan pipeline data, Cloud Data Fusion akan menerapkan transformasi ke setiap nilai dalam kolom. Misalnya, di kolom
yang disebut Name, Anda mengganti string Doctor dengan Dr. menggunakan langkah-langkah
sebelumnya. Wrangler menambahkan perintah find-and-replace Name s/Doctor/Dr./g ke
resep.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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)."]]
