User manual

Chapter 2 | Using databases 35
Words with zero or more unknown or
variable text characters in a row (zero
or more characters)
* for all unknown characters Jo*n finds Jon and John
J*r finds Jr. and Junior
*phan* finds Phan and Stephanie
Operators or other non-alphanumeric
characters, such as punctuation or
spaces
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
A character with special meaning,
such as the find operators recognized
by FileMaker
Pro: @, *, #, ?, !, =, <, >,
" (escape next character)
\ followed by the special
character
\"Joey\" finds "Joey"
joey\@abc.net finds the email
address [e-mail]
Words with accented characters The literal text (characters),
including spaces and
punctuation, between double
quotation marks (")
"òpera" finds òpera but not opera
(òpera without quotation marks finds
both òpera and opera)
Partial phrases, a sequence of words
or characters (match phrase from
anywhere)
Characters, punctuation, and
spaces between double quotation
marks ("); use * to find this text in
the middle of a longer text string
*"son & Phillips" finds Johnson
& Phillips and Paulson & Phillips
Exact matches of the text you specify
(match entire field)
== (two equal signs) for a field
content match
==John finds John but not John
Smith
==John Smith finds John Smith but
not Smith, John or John Smithers
Exact matches of whole words you
specify (match whole word)
= =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)
The characters 京都 finds 京都 , 東京都 , and 京都府
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
~ は finds は , ば , ぱ , ハ , バ , and パ
Ranges of information See “Finding ranges of
information” on page 37.
Case-sensitive text Change the default language for
indexing the field to Unicode.
Note This procedure will
change the order in which
records sort. For more
information, see Help.
fred finds fred but not Fred
To find Type this in the field Examples