transformations:searchfilter
Differences
This shows you the differences between two versions of the page.
| — |
transformations:searchfilter [2017/12/23 15:04] (current) dmitry created |
||
|---|---|---|---|
| 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: 2017/12/23 15:04 by dmitry
Page Tools
