transformations:massreplace
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
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: |
+ | ====== TABLE-WIDE REPLACE ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | This action is typically used for data cleansing, e.g. for removing the work ' | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Search for|Enter the value to search for.| | ||
+ | |where it' | ||
+ | |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. | ||
+ | |Perform replacement in|Select whether to search all or specific columns. | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | This action is case-sensitive. | ||
+ | |||
+ | Numeric values can only be searched for, and replaced as, entire cell values. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464|Asia | ||
+ | | Ob | 5410|Asia | ||
+ | | Paraná | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Search for: " | ||
+ | > where it's: Entire cell or part of longer text | ||
+ | > Replace with: " | ||
+ | > which is: Entire cell | ||
+ | > Perform replacement in: All columns | ||
+ | |||
+ | |||
+ | \\ | ||
+ | **Output table:** | ||
+ | |||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464|Asia | ||
+ | | Ob | 5410|Asia | ||
+ | | Paraná | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
- | It's typically used for data cleansing, e.g. for removing word ' |
transformations/massreplace.txt · Last modified: 2021/07/19 02:17 by craigt