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 | ||
| + | | Yangtze | ||
| + | | Mississippi | ||
| + | | Yenisei | ||
| + | | Yellow River | 5464 | Asia | | ||
| + | | Ob | 5410 | Asia | | ||
| + | | Paraná | ||
| + | |||
| + | |||
| + | **Objective: | ||
| + | |||
| + | **Transformation parameters: | ||
| + | |||
| + | * Column: River | ||
| + | * Search type: Starts with | ||
| + | * Search string: Y | ||
| + | |||
| + | **Output table:** | ||
| + | ^ River ^ Length (km) ^ Continent | ||
| + | | Yenisei | ||
| + | | Yellow River | 5464 | Asia | | ||
transformations/searchfilter.txt · Last modified: 2017/12/23 15:04 by dmitry
Page Tools
