Differences

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

--- transformations:massreplace [2015/04/10 16:05] – elenap
+++ transformations:massreplace [2021/04/19 00:43] – craigt
@@ Line 1: / Line 1: @@
-===== Table-wide replace =====
+{{ transformations:MassReplaceAction.png}}
+====== TABLE-WIDE REPLACE ======
+Category: Transform / Advanced\\
-This transformation performs the same replacement in all or selected columns.
+\\
+=====Description=====
+This action performs the same replacement in all or selected columns.\\
-It's typically used for data cleansing, e.g. for removing word 'NULL' in all columns.
+\\
+=====Use cases=====
+This action is typically used for data cleansing, e.g. for removing the work 'NULL' in all columns.\\
-EXAMPLE
+\\
+=====Action settings=====
+^Setting^Description^
+|Search for|Enter the value to search for.|
+|where it's|Select whether to match whole-cell values, or whole-cell values //and// partial values.  Options:  //Entire cell only// or //Entire cell or part of longer text//.|
+|Replace with|Enter the value to replace the search value with.|
+|which is|Select whether the replacement value will occupy the entire cell or just the matching portion of the found search value.  Options:  //Entire cell// or //Matching part//.|
+|Perform replacement in|Select whether to search all or specific columns.  Options: //All columns// or //Selected columns// (and select the column(s) to search from the list).|
-**Source table:** The longest rivers in the world
+\\
+=====Remarks=====
+This action is case-sensitive.  If the //Search for// value does not match values case-wise, the replacement is not made.
-^  River  ^  Length (km)  ^  Continent  ^
+Numeric values can only be searched for, and replaced as, entire cell values.  Upon entering a numeric value in the //Search for// field, only the //Entire cell only// options will be selectable.\\
-| Nile  |  6650  |  Africa  |
-| Amazon  |  6400  |  South America  |
-| Yangtze  |  6300  |  Asia  |
-| Mississippi  |  6275  |  North America  |
-| Yenisei  |  5539  |  Asia  |
-| Yellow River  |  5464  |  Asia  |
-| Ob  |  5410  |  Asia  |
-| Paraná  |  4880  |  South America  |
+\\
+=====Examples=====
-**Objective:** Replace "North America" or "South America" by simply "America"
+**Objective:** Replace "North America" or "South America" with simply "America".\\
-**Transformation parameters:**
+**Source table:** The longest rivers in the world
-  * Search for: America
+^River  ^Length (km)  ^Continent  ^
-  * where it's: Entire cell or part of longer text
+| Nile  |  6650|Africa  |
-  * Replace with: America
+| Amazon  |  6400|South America  |
-  * which is: Entire cell
+| Yangtze  |  6300|Asia  |
-  * Perform replacement in: All columns
+| Mississippi  |  6275|North America  |
+| Yenisei  |  5539|Asia  |
+| Yellow River  |  5464|Asia  |
+| Ob  |  5410|Asia  |
+| Paraná  |  4880|South America  |
+\\
+**Action parameters:**
+> Search for: "America"
+> where it's: Entire cell or part of longer text
+> Replace with: "America
+> which is: Entire cell
+> Perform replacement in: All columns
+\\
 **Output table:**
-^  River  ^  Length (km)  ^  Continent  ^
+^River  ^Length (km)  ^Continent  ^
-| Nile  |  6650  |  Africa  |
+| Nile  |  6650|Africa  |
-| Amazon  |  6400  |  America  |
+| Amazon  |  6400|America  |
-| Yangtze  |  6300  |  Asia  |
+| Yangtze  |  6300|Asia  |
-| Mississippi  |  6275  |  America  |
+| Mississippi  |  6275|America  |
-| Yenisei  |  5539  |  Asia  |
+| Yenisei  |  5539|Asia  |
-| Yellow River  |  5464  |  Asia  |
+| Yellow River  |  5464|Asia  |
-| Ob  |  5410  |  Asia  |
+| Ob  |  5410|Asia  |
-| Paraná  |  4880  |  America  |
+| Paraná  |  4880|America  |
+\\
+=====See also=====
+  * [[transformations:Lookup|Lookup]]
+  * [[transformations:match|Match]]
+  * [[transformations:replace|Replace]]