Differences

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

--- transformations:massreplace [2015/01/29 23:10] – created dmitry
+++ 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.\\
+\\
+=====Use cases=====
+This action is typically used for data cleansing, e.g. for removing the work 'NULL' in all columns.\\
+\\
+=====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).|
+\\
+=====Remarks=====
+This action is case-sensitive.  If the //Search for// value does not match values case-wise, the replacement is not made.
+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.\\
+\\
+=====Examples=====
+**Objective:** Replace "North America" or "South America" with simply "America".\\
+**Source table:** The longest rivers in the world
+^River  ^Length (km)  ^Continent  ^
+| 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  |
+\\
+**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  ^
+| Nile  |  6650|Africa  |
+| Amazon  |  6400|America  |
+| Yangtze  |  6300|Asia  |
+| Mississippi  |  6275|America  |
+| Yenisei  |  5539|Asia  |
+| Yellow River  |  5464|Asia  |
+| Ob  |  5410|Asia  |
+| Paraná  |  4880|America  |
+\\
+=====See also=====
+  * [[transformations:Lookup|Lookup]]
+  * [[transformations:match|Match]]
+  * [[transformations:replace|Replace]]
-It's typically used for data cleansing, e.g. for removing word 'NULL' in all columns.