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.

  1. Searching for “ple” will find “Plenty” and “Plexiglas” but not “Apple”

  2. “Apple” will match every item that includes words that start with Apple, and will match items with the values "Apples are tasty" and "This is an apple".

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.