transformations:replace
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:replace [2018/01/11 21:03] – dmitry | transformations:replace [2021/07/17 23:37] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Replace | + | {{ transformations: |
+ | ====== | ||
+ | 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. | ||
- | This transformation replaces particular values in a column | + | \\ |
+ | =====Use cases===== | ||
+ | Replacing mistyped names and words with correct ones. | ||
- | **Use cases** | + | If used together with the [[transformations: |
- | Replacing mistyped names and words with correct ones. | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column|Select the column in which values will be replaced.| | ||
+ | |Before / After|Select the value(s) to be replaced | ||
+ | |If a value to be replaced is missing|Select how EasyMorph will react if a selected value is not in the selected column.\\ | ||
+ | |Show missing|This option only appears when //Ignore// is selected for the //If a value to be replaced is missing// option, above.\\ | ||
- | If used together with the [[transformations: | + | The //search box// can be used to find a specific |
- | **See also** | + | \\ |
+ | =====Remarks===== | ||
+ | Only //whole// values are replaced with this action, not partial matches.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Example: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^River | ||
+ | | Nile | 6650| 4132|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Continent column. | ||
+ | > (Before) N. America: (After) North America | ||
+ | > (Before) S. America: (After) South America | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | |||
+ | ^River | ||
+ | | Nile | 6650| 4132|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action:\\ | ||
+ | |||
+ | *Right-click on the value to replace in a dataset and select " | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | | ||
+ | | ||
* [[transformations: | * [[transformations: | ||
+ | |||
+ |
transformations/replace.1515722628.txt.gz · Last modified: 2018/01/11 21:03 by dmitry