User manual

Finding and sorting information 3-3
To find Type this in the field Example
Symbols or other non- The characters, "@" finds @ (or an email
alphanumeric characters, including spaces and address, for example)
such as punctuation or punctuation, between the
"," finds records
spaces double quotation marks
containing a comma
(").
" " finds three
spaces in a row
Words with letters from The text, including "òpera" finds òpera but
other languages spaces and punctuation, not opera
between the double
(òpera without quotes
quotation marks (").
finds both òpera and
opera)
Partial phrases (a Characters, punctuation, *"son & Phillips"
sequence of words or and spaces between finds
characters) quotation marks (""). Johnson & Phillips and
Use * to find this text in Paulson & Phillips
the middle of a longer
text string.
Case-sensitive text (Use ASCII as the fred finds fred
language for indexing but not Fred
the field. This procedure
is documented in Help.
Choose Help menu >
Contents and Index, click
the Index tab, and type
text, finding.
Exact matches See the next section,“Finding exact matches in text
fields.”
Ranges of information See page 3-4.
Note Finds using quotes (“ ”) are called literal text searches. These
searches take longer than non-literal text searches.
Finding exact matches in text fields
To find values that are Use Example
Exactly as you specify, in the == (two equal ==John finds John but
order you specify. The field signs) not John Smith
contains no other values. ==John Smith finds
John Smith but not
Smith, John or John
Smithers
Whole words you specify. = =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
Finding numbers, dates, and times
Numbers, dates, and times should be entered in the corresponding
field types (or calculation fields returning the corresponding field
type) to ensure correct behavior when finding them. See “About
choosing a field type” on page 5-4. You cannot find text in number
fields, except certain letters representing Boolean (True/ False)
values; see table below.
Important To avoid confusion when using dates, always use four-
digit years. For more information on how FileMaker Pro handles
Year 2000 issues, see www.filemaker.com.
To find Type this in the field Example
A number in a number The number, in the .50 finds .5, .50, and $.50
field or in a calculation format used when the file
field that produces a was created (unless Use
numeric result System Formats is
chosen)