|
 
HOME
PREVIOUS
NEXT
Getting Started
Using FIND
Functions
When you perform a find, Dharma
Tribe searches through all the records in a
table, comparing the
criteria you specify with the data in the table. Records with data
matching the criteria become the
found set, which is the
subset of records being browsed. Records that don't match are omitted.
You can then constrain (narrow) or extend (broaden) the found set.
You can work with just the records
in the found set. For example, you can view, edit, calculate summaries
for,
sort, print, delete,
export, or replace data in these records. You can also open
another window in order to perform different find requests on the same
data.
Making a find
request
To find records, work in
Find mode. You type
criteria (the value or values to find) into
fields in a
find request, which looks like a
blank record. When you perform the find, Dharma Tribe searches for
records that match the criteria you entered. Matching records replace
any previous
found set.
To make a find request:
|
1.
|
Go to screen that contains
the
fields you want to search for. |
If necessary, you can change
layouts and enter criteria on more than one layout.
|
2.
|
Click the Find
button located on each page or CTRL&F (Windows) or
APPLE&F (Mac) |
|
3.
|
In the find request,
select a text, number, date, time, timestamp, or
calculation field to use for finding, and then type a
value in the field. |
Finding text and
characters
You can search for text in
fields of type text, or in
calculation fields that return a text result.
Unless you search for phrases and
exact matches, 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.
To find text and characters:
|
2.
|
Refer to the following
table for examples of different ways to search for text. |
| |
|
To find |
Type this in the field
|
Examples |
|
Words that start with Roman characters
|
The characters |
Chris Smith
finds Chris Smith,
Smith Chris,
Chris Smithson,
and Smith
Christenson
|
| |
|
|
|
A
phrase or sequence of characters
|
The text, including spaces and punctuation,
between the double quotation marks (").
|
"Marten and Jones
Interiors"
finds Marten and
Jones Interiors but not
Jones and Marten
Interiors
", Ltd."
finds all companies with
", Ltd."
in the name, but not those without the
comma.
|
|
Words with one or more unknown or variable
characters |
One wildcard character (@)
for each unknown character. |
Gr@y
finds Gray and
Grey
@on
finds Don and
Ron but not
Bron
|
|
Invalid characters in a text field
|
?
|
Invalid characters display as blank
characters |
|
Digits in a text field |
A
# character for each digit |
#
finds 3 but not
30
##
finds 30 but
not 3 or
300
#3
finds 53 and
43 but not
3
|
|
Words with zero or more unknown or variable
text characters in a row |
*
for all unknown characters.
|
Jo*n
finds Jon and
John
J*r
finds Jr. and
Junior
*phan*
finds
Phan and
Stephanie
|
|
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
|
|
A
character with special meaning, such as the
find symbols recognized by FileMaker Pro:
@,
*, #, ?, !, =, <, >, " |
\
followed by the special character
|
\"Joey\"
finds "Joey"
Joey\@abc.net
finds the email address
Joey@abc.net
|
|
Words with accented characters |
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
the 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
|
==
(two equal signs) |
==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
|
=
|
=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
|
|
|
|
3.
|
When you've entered the
find criteria that you want, click Find
in the status area, or choose Requests
menu > Perform Find. |
Notes
| |
Normally, finds are not
case sensitive or width sensitive. For example: |
|
|
| |
A find for
fred finds
Fred and
FRED. |
|
|
|
| |
A find request
that includes Japanese half-width characters will match
results that contain the equivalent full-width
characters. |
|
Finding numbers,
dates, times, and timestamps
Numbers, dates, times, and
timestamps should be entered in the corresponding
field types (or
calculation fields returning the
corresponding field type) to ensure correct behavior when finding them.
|
Important Entering two-digit year
dates along with Find operators in a
find request will be interpreted as four-digit dates
based on a conversion algorithm. For example, entering a find
request as
1/1/07 .. 12/31/08 will find
the years 2007 through 2008 if the current year is 2007. It is
strongly recommended that complete four-digit years be used to
avoid possible confusion. For more information about the
conversion algorithm, see
Conversion of dates with two-digit years. |
|
|
To find numbers, dates, times,
and timestamps:
|
2.
|
Refer to the following
table for examples of different ways to search for numbers,
dates, times, and timestamps. |
| |
|
To find |
Type this in the field
|
Examples |
|
A
number in a number field or in a calculation
field that produces a numeric result
|
The number |
.50
finds .5,
.50, and
$.50
|
|
One or more digits in a number field or in a
calculation field that produces a numeric
result |
A
# character for each digit |
#
finds 3 but not
30
##
finds 30 but
not 3 or
300
#3
finds 53 and
43 but not
3
|
|
A
Boolean number in a number field or in a
calculation field that produces a Boolean
result |
1
to find
True
values
0
to find
False
values
|
1
finds 1
0
finds 0
|
|
Invalid data (fields with no numeric digits)
in a number field or calculation field that
produces a numeric result |
?
|
?
finds twelve
but not 12 or
twelve30
|
|
A
date in a date field or in a calculation
field that produces a date result
|
The date as digits, separated by a valid
date separator character (such as a slash or
hyphen) |
3/3/2007
finds 3/3/2007,
March 3, 2007,
and 3-3-2007
|
|
Today's date in a date field or in a
calculation field that produces a date
result |
//
|
//
finds April 4, 2007
(when the current date is 4/4/2007)
|
|
A
time in a time field or in a calculation
field that produces a time result
|
The time as digits, separated by colons
|
12:53:09
finds 12:53:09
|
|
A
timestamp in a timestamp field or in a
calculation field that produces a timestamp
|
The date as digits, separated by a valid
date separator character, then the time as
digits, separated by colons |
3/3/2007 12:59:09 PM
finds
3/3/2007 12:59:09
PM
|
|
Invalid dates, times, timestamps, or
calculated date or time results |
?
|
?
finds Next Tuesday
or 2/33/2007 in
a date field, or
midnight in a time field
|
|
Dates on a day of the week in a date or
timestamp field |
The day of the week
Note Full or
short day names (for example, Friday or Fri)
are acceptable in day of week searches
|
Tuesday
finds all dates that occur on a Tuesday
=Thu
finds all dates that occur on a Thursday
|
|
Any valid value for a date or time component
in a date, time, or timestamp field
|
*
or leave component unspecified, while
specifying the other components you want to
find |
5/12/*
finds the 12th day of May in any year
5/12
finds the 12th day of
May in the current year
*:15
finds times 15 minutes after any hour
1/1/* 7 PM
finds timestamps in the 7 o'clock PM hour on
January 1st in any year
|
|
Ranges of information |
See
Below. |
|
|
|
3.
|
When you've entered the
find criteria that you want, click Find
in the status area, or choose Requests
menu > Perform Find. |
Notes
| |
When you enter numbers,
dates, days of the week, times, and timestamps into find
requests, always enter them using the appropriate system or file
settings that are in use. |
| |
When you perform day of
the week searches on systems set to a language other than
English, you may use English day names and abbreviations if you
wish. The English names are supported in all
system formats. For more information on system
formats, see
Opening files with foreign system formats. |
| |
When you perform day of
the week searches, the first day of the week depends on your
system settings. Sunday is the first day of the week in English
and Japanese, but Monday is the first day of the week in German,
French, Italian, Swedish, Dutch, Spanish, and other system
formats that FileMaker Pro supports. |
Finding ranges of
information
You can find ranges of
information, such as all records that contain a field value that is
greater or less than a number, or between two particular dates. A range
is different based on the data type:
| |
Numbers:
least to greatest |
| |
Dates,
times, and timestamps: earliest to latest |
| |
Text:
first to last word, based on the
index order of words (not the sort order). A word can
be a single character; for example, a find on a field for
<M would return every record
that contains a word less than
M in the field's index order. |
To find ranges of information:
|
2.
|
Refer to the following
table for examples of different ways to search for a range of
information. |
| |
|
To find values that are
|
Use this operator
|
Examples |
|
Less than a specified value. |
<
|
<40
<9/7/2007
<M
|
|
Less than or equal to a specified value.
|
<=
or
£
|
<=95129
£05:00:00
<=M
|
|
Greater than a specified value. |
>
|
>95129
>9/7/2007
>M
|
|
Greater than or equal to a specified value.
|
>=
or
³
|
>=100
>=9/7/2007
³8:00
³M
|
|
Within the range you specify. |
..
or ...
(two or three periods) |
12:30...17:30
1/1/2007..6/6/2008
A...M
Mon..Fri
|
|
Within the sub-range you specify.
|
{..} or {...}
(two or three periods) |
7/{1...15}/2007
{1..3}/{10..16}/2007
12:{30..45}
{7...9}:15 PM
|
|
Based only on certain date or time
components such as month, year, or minutes.
(See more examples below.) |
*
or type nothing for each component you don't
want to specify |
3/*/2007
2/*
2007 *:30 PM
|
|
|
|
3.
|
When you've entered the
find criteria that you want, click Find
in the status area, or choose Requests
menu > Perform Find. |
Notes
| |
When searching for ranges
of information in date, time, and timestamp fields, you don't
have to specify all date or time components. For example, you
can type 5/2007
instead of
5/1/2007...5/31/2007 to find
all dates in May, 2007. |
| |
You can combine operators
to simplify range searches. For example, type
*/{10..15}/2007
to search for all dates in 2007, but only for days from the 10th
through the 15th. |
| |
Refer to the following
tables for examples of different ways to search for dates,
times, and timestamps. |
| |
|
To find dates
|
Type this in the field
|
|
In
June, 2007 |
6/2007
|
|
From July 2007 through October 2008
|
7/2007...10/2008
|
|
That occur on a Friday |
=Friday
|
|
From the 10th through the 16th of October or
November, 2007 |
{10..11}/{10..16}/2007
|
|
That occur on March 1st between 1868 and
1912 in the Japanese Emperor Year era of
Meiji |
m*/3/1
|
|
That occur on December 31st between 1930 and
1940 in the Japanese Emperor Year era of
Showa |
S{5..15}+12+31
|
|
|
|