How search works in TIBCO Spotfire when a search phrase is specified in quotes

How search works in TIBCO Spotfire when a search phrase is specified in quotes

book

Article ID: KB0076762

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

When searching in TIBCO Spotfire, at times searching a value with phrases may not give the expected result in listbox filter of Spotfire. For example, if the values in list box filter are:
abcd
abc
abc d
abc-d
abc1d
Searching for "abc" (with quotes) returns the following:
abc
abc d
abc-d
Why are three values returned instead of only "abc"? Why isn't "abcd" returned?

Issue/Introduction

This article explains how search works in TIBCO Spotfire when the phrase is in quotes (eg. "example")

Resolution

When searching for a phrase specified in quotes, they are matched at word boundaries. A word boundary is something that starts with a word character <A-Z> or <a-z> or <0-9> or _ and ends with a non-word character like space and special characters. Therefore "abc", "abc d", and "abc-d" all contain the full word "abc" and are returned. The value "abcd" is not returned as "abc" is not present as a complete word within the string.

Alternatively, searching for abc (without quotes) would list all of the above values as it will only search if the abc is present in the string at all, not considering word boundaries.

Additional Information

Doc: Searching in TIBCO Spotfire

External: Word Boundaries