Unless you search for phrases or an exact match, the field can contain other values in addition to the one(s) you specify, and the values can be in any order. For example, typing
hotel in a field named Accommodation finds
records for
Hotel,
Discount Hotel, and
Hotels,
Luxury.
|
|
|
Words that start with specific Roman characters (works with fields that use any language except Japanese)
|
|
Chris Smith finds Chris Smith, Smith Chris, Chris Smithson, and Smith Christenson
|
|
|
|
A phrase or sequence of characters that match when they are the first characters in a word (match phrase from word start)
|
The literal text (characters), including spaces and punctuation, between double quotation marks ( ")
|
", Ltd." finds all companies with " , Ltd." in the name, but not those without the comma
“Spring” finds Springville but not ColdSpring Harbor or HotSpring
|
|
|
@on finds Don and Ron but not Bron
|
|
|
Note To find the ? character, search for "?"
|
|
|
## finds 30 but not 3 or 300
#3 finds 53 and 43 but not 3
|
|
* for all unknown characters
|
*phan* finds Phan and Stephanie
S* finds Sophie, Steve, and Sven
|
|
The literal text (characters), including spaces and punctuation, between double quotation marks ( ")
|
"@" finds @ (or an email address, for example)
"," finds records containing a comma
" " finds three spaces in a row
|
|
|
\"Joey\" finds "Joey" joey\@abc.net finds the email address joey@abc.net
|
|
The literal text (characters), including spaces and punctuation, between double quotation marks ( ")
|
(òpera without quotation marks finds both òpera and opera)
|
|
Characters, punctuation, and spaces between double quotation marks ( "); use * to find this text in the middle of a longer text string
|
|
|
|
==John finds John but not John Smith
==John Smith finds John Smith but not Smith, John or John Smithers
|
|
|
=Market finds Market, Market Services, and Ongoing Market Research but not Marketing or Supermarket
=Chris =Smith finds Chris Smith or Smith Chris but not Chris or Christopher Smithson
|
Words that contain Japanese Hiragana, Katakana, and Kanji characters (Japanese-indexed fields only)
|
|
|
Kana characters in a Japanese-indexed field without differentiating between Hiragana/Katakana, Voiced/Semi-Voiced/Unvoiced Kana, Small/Regular Kana, and Kana Voiced/Unvoiced Iteration Marks
|
~ (tilde) and the character, to do a relaxed search
|
|
You can perform case-sensitive and width-sensitive finds on a field by changing the default indexing and sorting language for the field to
Unicode. However, this procedure will change the order in which the field sorts. If you do not want the original field to sort in Unicode order, create a
calculation field whose
formula is simply the field in which you want to perform case-sensitive or width-sensitive finds, and change the default indexing and sorting language of this field to Unicode. Then you can sort one of the fields, and perform find requests on the other. For more information, see
Defining field indexing options and
Defining calculation fields.