Formatting Searches in Spotfire List Filters
Introduction
By default, a search will match against the beginning of all words in each value in the list.
Guidelines
Tip #1: As you type, a search will be become more refined.
For example, if you are searching a list of the months of the year, as you type each letter, the number of months matching the search will decrease.
Typed in Text Filter | Filtered rows |
j | January, June, July |
ju | June, July |
jun | June |
june | June |
Tip #2: Keywords can be used to write more specific search strings
The table below outlines the function for each keyword and example search uses.
Keyword | Example | Function |
* | *ple *ple* | Finds items with a word ending in ple. Finds items where a word contains ple. |
Quotation marks | "A Green Apple" | Finds items where the word starts with the phrase "A Green Apple". |
Double quotation marks | "9"" nails" | Finds items where the word starts with 9" nails. Add a second double quote to escape a literal quote. |
AND | Apple AND Fruit | Finds items with a word that starts with Apple and another word that starts with Fruit. |
OR | Apple OR Banana | Finds items that include a word that starts with Apple or Banana. |
NOT | Ban NOT *ana | Finds items that have a word that starts with Ban but does not end with ana. For example, Bangles and Banned would be found, but Banana would not. |
( ) | Apple and (Banana or Pear) | Used to group items in Boolean searches. |
Quoted keywords | "and" "or" "not" | Finds strings that are protected keywords. Just typing and in the search field will not find anything since the word and is a protected keyword. If you need to search for the word "and", you must use quotation marks around it. |
Click here to read examples about filter list searching from TIBCO® Spotfire.