Using text filters
The text filter is used to filter to values that match an entered text string.
About this task
You type a text string in the field. Only rows with values matching the text string remain in the visualization. Below you find tips on how to search for wanted values:
- The text filter is not case-sensitive.
- A blank space between two search words will result in rows containing both words.
- Search for june OR may to find rows containing either of those months.
- Use *son to search for rows ending in "son" (Anderson, Jamesson, etc.), and use *sun* to search for rows containing the letters "sun" somewhere (Sunday, Asunder, etc.).
- Use quotation marks "sample batch alpha" to search for explicit phrases.
- Non-alphanumeric characters are not considered to be included in words, and if no quotation marks are used, matching is done on word boundaries. Add quotation marks to include special characters in the search string.
Procedure
- Type the text in the field.
- Press Enter.
Example
Assume you have a data column with all the months of the year, that
is, January, February, March, ..., and December. Below you can see which values
remain after typing different text strings.
| Typed in Text Filter | Filtered rows |
| j | January, June, July |
| ju | June, July |
| jun | June |
| june | June |