User manual

Finding and sorting information 3-3
Note Finds using quotes (“ ”) are called literal text searches. These
searches take longer than non-literal text searches.
Finding exact matches in text fields
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 5 handles
Year 2000 issues, see www.filemaker.com.
Symbols or other non-
alphanumeric characters,
such as punctuation or
spaces
The characters,
including spaces and
punctuation, between the
double quotation marks
(").
"@" finds @ (or an email
address, for example)
"," finds records
containing a comma
" " finds three
spaces in a row
Words with letters from
other languages
The text, including
spaces and punctuation,
between the double
quotation marks (").
"òpera" finds òpera but
not opera
(òpera without quotes
finds both òpera and
opera)
Partial phrases (a
sequence of words or
characters)
Characters, punctuation,
and spaces between
quotation marks ("").
Use * to find this text in
the middle of a longer
text string.
*"son & Phillips"
finds
Johnson & Phillips and
Paulson & Phillips
Case-sensitive text (Use ASCII as the
language for indexing
the field. This procedure
is documented in Help.
Choose Help menu >
Contents and Index, click
the Index tab, and type
text, finding.
fred finds fred
but not Fred
Exact matches See the next section,“Finding exact matches in text
fields.”
Ranges of information See page 3-4.
To find Type this in the field Example
To find values that are Use Example
Exactly as you specify, in the
order you specify. The field
contains no other values.
== (two equal
signs)
==John finds John but
not John Smith
==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
To find Type this in the field Example
A number in a number
field or in a calculation
field that produces a
numeric result
The number, in the
format used when the file
was created (unless Use
System Formats is
chosen)
.50 finds .5, .50, and $.50