User Tools

Site Tools


transformations:massreplace

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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