transformations:massreplace
Differences
This shows you the differences between two versions of the page.
|
transformations:massreplace [2015/01/30 04:10] dmitry created |
transformations:massreplace [2015/04/10 20:05] (current) elenap |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| It's typically used for data cleansing, e.g. for removing word 'NULL' in all columns. | It's typically used for data cleansing, e.g. for removing word 'NULL' in all columns. | ||
| + | |||
| + | EXAMPLE | ||
| + | |||
| + | **Source table:** The longest rivers in the world | ||
| + | |||
| + | ^ River ^ Length (km) ^ Continent ^ | ||
| + | | Nile | 6650 | Africa | | ||
| + | | Amazon | 6400 | South America | | ||
| + | | Yangtze | 6300 | Asia | | ||
| + | | Mississippi | 6275 | North America | | ||
| + | | Yenisei | 5539 | Asia | | ||
| + | | Yellow River | 5464 | Asia | | ||
| + | | Ob | 5410 | Asia | | ||
| + | | Paraná | 4880 | South America | | ||
| + | |||
| + | |||
| + | **Objective:** Replace "North America" or "South America" by simply "America" | ||
| + | |||
| + | **Transformation parameters:** | ||
| + | |||
| + | * Search for: America | ||
| + | * where it's: Entire cell or part of longer text | ||
| + | * Replace with: America | ||
| + | * which is: Entire cell | ||
| + | * Perform replacement in: All columns | ||
| + | | ||
| + | **Output table:** | ||
| + | |||
| + | ^ River ^ Length (km) ^ Continent ^ | ||
| + | | Nile | 6650 | Africa | | ||
| + | | Amazon | 6400 | America | | ||
| + | | Yangtze | 6300 | Asia | | ||
| + | | Mississippi | 6275 | America | | ||
| + | | Yenisei | 5539 | Asia | | ||
| + | | Yellow River | 5464 | Asia | | ||
| + | | Ob | 5410 | Asia | | ||
| + | | Paraná | 4880 | America | | ||
transformations/massreplace.txt · Last modified: 2015/04/10 20:05 by elenap
Page Tools
