User Tools

Site Tools


transformations:searchfilter
no way to compare when less than two revisions

Differences

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


Next revision
transformations:searchfilter [2017/12/23 10:04] – created dmitry
Line 1: Line 1:
 +===== Filter by search =====
  
 +This transformation keeps or removes rows where values in specified column contain particular substring. It also supports filtering using a regular expression.
 +
 +**Example of transformation**
 +
 +**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:** Find all rivers that start with 'Y'.
 +
 +**Transformation parameters:**
 +
 +  * Column: River
 +  * Search type: Starts with
 +  * Search string: Y
 +
 +**Output table:**
 +^  River  ^  Length (km)  ^  Continent  ^
 +| Yenisei  |  5539  |  Asia  |
 +| Yellow River  |  5464  |  Asia  |
transformations/searchfilter.txt · Last modified: 2021/07/19 02:15 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki