The text filter lets you type a string of text, and any values that do not match the entered string are filtered out. As you type the string, the visualization is continuously updated with the values that begin with the current substring.
For example, consider a column with all the months of the year, January, February, March, ... , December.
Typed in text filter |
Filtered rows |
j |
January, June, July |
ju |
June, July |
jun |
June |
june |
June |
Note: The example above is only applicable to in-memory data. If your data comes from an external data connection, you must add wildcards (*) to retrieve columns beginning with a letter or a number of letters, e.g., ju*.
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 exact phrases.
Searching Date,
Time and DateTime:
Date and time can be formatted and displayed in a multitude of ways.
When searching for date or time, always search using the same syntax
as displayed in the document. The separators between year, month,
day will be treated as word separators.
For example, suppose dates are displayed in a table visualization in
the YYYY-MM-DD notation.
Searching for 05 would match dates such as: 2005-05-27 or 1998-12-05.
Searching for *05 would match dates such as: 2005-12-30 or 1997-05-22
or 1879-10-05.
Searching for 04-2 would match dates such as: 1998-04-21 or 2005-04-29.
Time can sometimes be displayed using a notation with colon, for example:
11:45pm or 23:45.
The colon is a protected keyword, which means that to search for such
a time you need to enclose the time within quotation marks: "23:45".
Just searching for 23:45 without the quotation marks will not
provide any matches.
Searching Currency: Depending on how a column of currency values is presented, it can have various symbols before or after the digits. When searching, do not enter these symbols, just search for the value. For example, searching for 550 would find $550, £550 or 500kr.
For a listing of more search alternatives, see Searching in TIBCO Spotfire.
See also: