Differences

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

--- transformations:replace [2018/01/11 21:02] – dmitry
+++ transformations:replace [2021/03/21 12:57] – craigt
@@ Line 1: / Line 1: @@
-===== Replace =====
+{{ transformations:ReplaceAction.png}}
+====== REPLACE ======
+Category: Transform / Basic
-Category: Transformation / Basic
+=====Description=====
+This action replaces particular values in a column with new values. The new values can be either text or numbers.  Multiple old values can be replaced with the same new value.
-This transformation replaces particular values in a column with new values. The new values can be either text or numbers. Multiple old values can be replaced with the same new value.
-**Use cases**
+\\
+=====Action settings=====
+^Setting^Description^
+|Column|Select the column in which values will be replaced.|
+|Before / After|Select the value(s) to be replaced and enter the new values in the text boxes that appear to the right.|
+|If a value to be replaced is missing|Select how EasyMorph will react if a selected value is not in the selected column.\\  Options:  //Fail// (An error will be displayed for his action.) or //Ignore// (missing values will be skipped and the action will replace existing values.).|
+|Show missing|This option only appears when //Ignore// is selected for the //If a value to be replaced is missing// option, above.\\  The Before/After list will display the selected values that are missing in the column.|
+The //search box// can be used to find a specific value in large value lists.
+\\
+=====Use cases=====
 Replacing mistyped names and words with correct ones.
 If used together with the [[transformations:sequence|Sequence]] transformation, it allows defining relatively small custom lists. Use Replace to replace 1 with one custom value, 2 with another one, etc.
+\\
+=====Examples=====
+**Example:**  Expand the names of the "America" values (N. > North, S. > South).
+**Source table:** The longest rivers in the world
+^  River  ^  Length (km)  ^  Length (miles)  ^  Continent  ^
+| Nile  |  6650  |  4132  |  Africa  |
+| Amazon  |  6400  |  3976  |  S. America  |
+| Yangtze  |  6300  |  3917  |  Asia  |
+| Mississippi  |  6275  |  3902  |  N. America  |
+**Transformation parameters:**
+>  Continent column.
+>  (Before) N. America: (After) North America
+>  (Before) S. America: (After) South America
+**Output table:**
+^  River  ^  Length (km)  ^  Length (miles)  ^  Continent  ^
+| Nile  |  6650  |  4132  |  Africa  |
+| Amazon  |  6400  |  3976  |  South America  |
+| Yangtze  |  6300  |  3917  |  Asia  |
+| Mississippi  |  6275  |  3902  |  North America  |
+\\
+=====See Also=====
+  * [[transformations:sequence|Sequence]]