Differences

This shows you the differences between two versions of the page.

--- transformations:massreplace [2021/04/19 00:43] – craigt
+++ transformations:massreplace [2021/07/19 02:17] (current) – [Examples] craigt
@@ Line 9: / Line 9: @@
 \\
 =====Use cases=====
-This action is typically used for data cleansing, e.g. for removing the work 'NULL' in all columns.\\
+This action is typically used for data cleansing, e.g. for removing the word 'NULL' in all columns.\\
+Cleaning up the "(not set)" values that Google Analytics uses to represent blank cells.\\
 \\
@@ Line 29: / Line 31: @@
 =====Examples=====
-**Objective:** Replace "North America" or "South America" with simply "America".\\
+**Example:** Clean out NULL values from the source table, replacing them with blank cells.\\
 **Source table:** The longest rivers in the world
@@ Line 35: / Line 37: @@
 ^River  ^Length (km)  ^Continent  ^
 | Nile  |  6650|Africa  |
-| Amazon  |  6400|South America  |
+| NULL  |  6400|South America  |
-| Yangtze  |  6300|Asia  |
+| Yangtze  |  6300|NULL  |
-| Mississippi  |  6275|North America  |
+| Mississippi  |NULL  |North America  |
 | Yenisei  |  5539|Asia  |
-| Yellow River  |  5464|Asia  |
+| Yellow River  |  5464|NULL|
-| Ob  |  5410|Asia  |
+| Ob  |NULL  |NULL  |
 | Paraná  |  4880|South America  |
 \\
 **Action parameters:**
-> Search for: "America"
+> Search for: "NULL"
-> where it's: Entire cell or part of longer text
+> where it's "Entire cell only"
-> Replace with: "America
+> Replace with (leave blank)
-> which is: Entire cell
+> which is "Entire cell"
-> Perform replacement in: All columns
+> Perform replacement in "All columns"
 \\
-**Output table:**
+**Result table:**
 ^River  ^Length (km)  ^Continent  ^
 | Nile  |  6650|Africa  |
-| Amazon  |  6400|America  |
+|  |  6400|South America  |
-| Yangtze  |  6300|Asia  |
+| Yangtze  |  6300|  |
-| Mississippi  |  6275|America  |
+| Mississippi  |  |North America  |
 | Yenisei  |  5539|Asia  |
-| Yellow River  |  5464|Asia  |
+| Yellow River  |  5464|  |
-| Ob  |  5410|Asia  |
+| Ob  |  |  |
-| Paraná  |  4880|America  |
+| Paraná  |  4880|South America  |
 \\