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 | ||
+ | | 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: 2021/07/19 02:15 by craigt