Differences

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

--- transformations:searchfilter [2017/12/23 10:04] – created dmitry
+++ transformations:searchfilter [2021/07/19 02:15] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== Filter by search =====
+{{ transformations:SearchFilterAction.png}}
+====== FILTER BY SEARCH ======
+Category: Transform / Filters\\
-This transformation keeps or removes rows where values in specified column contain particular substring. It also supports filtering using a regular expression.
+\\
+=====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.\\
-**Example of transformation**
+\\
+=====Use cases=====
+Create subsets of a dataset based on parts of values in a specific column (literal strings or regular expressions).
-**Source table:** The longest rivers in the world
+Clean a dataset by removing records that may have "junk" data in a specific column.
-^  River  ^  Length (km)  ^  Continent  ^
+\\
-| Nile  |  6650  |  Africa  |
+=====Action settings=====
-| Amazon  |  6400  |  South America  |
+^Setting ^Description ^
-| Yangtze  |  6300  |  Asia  |
+|Column|Select the column containing the values to be used for filtering.  |
-| Mississippi  |  6275  |  North America  |
+|Search type|Select what part of the values should match the search string.  See the table below.|
-| Yenisei  |  5539  |  Asia  |
+|Search string<sup>*</sup>|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".|
-| Yellow River  |  5464  |  Asia  |
+|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 [[https://en.wikipedia.org/wiki/Regular_expression|regular expression]] for more information.|
-| Ob  |  5410  |  Asia  |
+|Case sensitive|When checked, case will not be considered when matching the search string.|
-| Paraná  |  4880  |  South America  |
+|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//.|
+<sup>*</sup> Setting can be specified using a [[:parameters|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).
-**Objective:** Find all rivers that start with 'Y'.
-**Transformation parameters:**
+\\
+=====Examples=====
+**Example:** Find all rivers that start with 'Y'.\\
-  * Column: River
+**Source table:** The longest rivers in the world
-  * Search type: Starts with
+^River  ^Length (km)  ^Continent  ^
-  * Search string: Y
+| Nile  |  6650| Africa  |
+| Amazon  |  6400| South America  |
-**Output table:**
+| 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  ^
-| Yenisei  |  5539  |  Asia  |
+| Yangtze  |  6300| Asia  |
-| Yellow River  |  5464  |  Asia  |
+| Yenisei  |  5539| Asia  |
+| Yellow River  |  5464| Asia  |
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//1475/1|Finding all projects with particular action]] ([[https://community.easymorph.com/uploads/short-url/cM8AssOT6zQXD8JDr9adUAy2sDM.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 2//; Action position: //3//)
+  * [[https://community.easymorph.com/t//1800/4|Download multiple files from HTTPS and copy to folder, preserving file names]] ([[https://community.easymorph.com/uploads/short-url/pQyGPi01bpxaWBHR6LdGlGMyRbH.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
+  * [[https://community.easymorph.com/t//2051/1|How to search a text file (e.g. task log) and see result in Server Pages]] ([[https://community.easymorph.com/uploads/short-url/7ZHCVj2p6RV5j6paCUZCnho29vK.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//;\\ Action position: //2//)
+\\
+=====See also=====
+  * [[transformations:selectionfilter|Filter]]
+  * [[transformations:filter|Filter by condition]]
+  * [[transformations:filterbytype|Filter by type]]
+  * [[transformations:regexp|Regular expression]]