FILTER BY SEARCH

Category: Transform / Filters

Description

This action keeps or removes rows where values in a specified column contain a particular substring. It also supports filtering using a regular expression.

Use cases

Create subsets of a dataset based on parts of values in a specific column (literal strings or regular expressions).

Clean a dataset by removing records that may have "junk" data in a specific column.

Action settings

Setting	Description
Column	Select the column containing the values to be used for filtering.
Search type	Select what part of the values should match the search string. See the table below.
Search string^*	Enter the string or regular expression to match in the selected column's values. If "Regular expression" is selected as the Search type, this setting changes to "Regular expression".
Regular expression	This setting appears when "Regular expression" is selected as the Search type. Enter the regular expression to be evaluated against all values in the selected column. See regular expression for more information.
Case sensitive	When checked, case will not be considered when matching the search string.
Filter mode	Select whether rows with matching values will be kept in the dataset, or removed. Options: Keep only matching values or Remove matching values.

^* Setting can be specified using a parameter.

Remarks

In cases where no values match the search string:

If Keep only matching values was selected, the result will be an empty dataset.
If Remove matching rows was selected, the result will be the full dataset (no rows removed).

Examples

Example: Find all rivers that start with 'Y'.

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

Action parameters:

Column is "River"
Search type is "Starts with"
Search string is "Y"

Result table:

River	Length (km)	Continent
Yangtze	6300	Asia
Yenisei	5539	Asia
Yellow River	5464	Asia

Community examples

Finding all projects with particular action (Project; Module: Main; Group: Tab 1; Table: Table 2; Action position: 3)
Download multiple files from HTTPS and copy to folder, preserving file names (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 3)
How to search a text file (e.g. task log) and see result in Server Pages (Project; Module: Main; Group: Tab 1; Table: Table 1;
Action position: 2)

EasyMorph Help

Table of Contents