transformations:replace
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:replace [2018/01/11 21:02] – created dmitry | transformations:replace [2021/03/21 12:57] – 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 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.\\ | ||
+ | |Show missing|This option only appears when //Ignore// is selected for the //If a value to be replaced is missing// option, above.\\ | ||
+ | |||
+ | 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. | Replacing mistyped names and words with correct ones. | ||
If used together with the [[transformations: | If used together with the [[transformations: | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Example: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^ River ^ Length (km) ^ Length (miles) | ||
+ | | Nile | 6650 | 4132 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | |||
+ | |||
+ | **Transformation parameters: | ||
+ | |||
+ | > Continent column. | ||
+ | > (Before) N. America: (After) North America | ||
+ | > (Before) S. America: (After) South America | ||
+ | |||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ River ^ Length (km) ^ Length (miles) | ||
+ | | Nile | 6650 | 4132 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | |||
+ | |||
+ | |||
+ | \\ | ||
+ | =====See Also===== | ||
+ | * [[transformations: | ||
+ |
transformations/replace.txt · Last modified: 2021/07/17 23:37 by craigt