{{ transformations:ReplaceAction.png}}
====== REPLACE ======
Category: Transform / 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.\\

\\ 
=====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.\\

\\ 
=====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.

\\ 
=====Remarks=====
Only //whole// values are replaced with this action, not partial matches.\\

\\ 
=====Examples=====

**Example:**  Expand the names of the "America" values ("N." to "North", "S." to "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  |
\\ 
**Action parameters:**
>  Continent column.
>  (Before) N. America: (After) North America
>  (Before) S. America: (After) South America
\\ 
**Result 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  |

\\ 
====Community examples====
  * [[https://community.easymorph.com/t//1590/4|Puzzler: derived column from two columns]] ([[https://community.easymorph.com/uploads/short-url/5OvCYyhfiaCg5XZU3nALaT5eql4.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //5//)
  * [[https://community.easymorph.com/t//1972/2|Read Data with two line header]] ([[https://community.easymorph.com/uploads/short-url/4YFQxslIv3pmgtF2eRywf4wpcFQ.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Read, Mark groups//; Action position: //7//)
  * [[https://community.easymorph.com/t//2060/2|Search, remove, and shift]] ([[https://community.easymorph.com/uploads/short-url/cCqOTak9SLKPXbityR5IAlgULJa.morph|Project]]; Module: //Main//; Group: //Regrouping//; Table: //ExtractingData.xlsx//; Action position: //6//)

\\ 
=====Shortcuts=====
Fast ways to create the action:\\

  *Right-click on the value to replace in a dataset and select "Replace (value)...".

\\ 
=====See also=====
  * [[transformations:replacewithlookup|Replace with lookup]]
  * [[transformations:lookup|Lookup]]
  * [[transformations:rule|Rule]]