transformations:massreplace
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:massreplace [2015/04/10 16:05] – elenap | transformations:massreplace [2021/07/19 02:17] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Table-wide replace | + | {{ transformations: |
+ | ====== TABLE-WIDE REPLACE ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | It' | + | \\ |
+ | =====Use cases===== | ||
+ | This action is typically used for data cleansing, e.g. for removing | ||
- | EXAMPLE | + | Cleaning up the "(not set)" values that Google Analytics uses to represent blank cells.\\ |
- | **Source table:** The longest rivers | + | \\ |
+ | =====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 | ||
- | ^ River ^ Length (km) ^ Continent | + | \\ |
- | | Nile | 6650 | Africa | + | =====Remarks===== |
- | | Amazon | + | This action is case-sensitive. |
- | | Yangtze | + | |
- | | Mississippi | + | Numeric values can only be searched for, and replaced as, entire cell values. |
- | | Yenisei | + | |
- | | Yellow River | 5464 | Asia | | + | \\ |
- | | Ob | 5410 | Asia | | + | =====Examples===== |
- | | Paraná | + | |
+ | **Example: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | NULL | 6400|South America | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464|NULL| | ||
+ | | Ob |NULL |NULL | | ||
+ | | Paraná | ||
- | **Objective:** Replace | + | \\ |
+ | **Action parameters:** | ||
+ | > Search for: "NULL" | ||
+ | > where it's " | ||
+ | > Replace with (leave blank) | ||
+ | > which is "Entire cell" | ||
+ | > Perform replacement in "All columns" | ||
- | **Transformation parameters:** | + | \\ |
+ | **Result table:** | ||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | | 6400|South America | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| | | ||
+ | | Ob | | | | ||
+ | | Paraná | ||
- | * Search for: America | + | \\ |
- | * where it's: Entire cell or part of longer text | + | =====See also===== |
- | * Replace with: America | + | * [[transformations:Lookup|Lookup]] |
- | * which is: Entire cell | + | * [[transformations:match|Match]] |
- | * Perform replacement in: All columns | + | * [[transformations:replace|Replace]] |
- | + | ||
- | **Output table:** | + | |
- | ^ River ^ Length (km) ^ Continent | ||
- | | Nile | 6650 | Africa | ||
- | | Amazon | ||
- | | Yangtze | ||
- | | Mississippi | ||
- | | Yenisei | ||
- | | Yellow River | 5464 | Asia | | ||
- | | Ob | 5410 | Asia | | ||
- | | Paraná |
transformations/massreplace.txt · Last modified: 2021/07/19 02:17 by craigt