Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 111
3. When you’ve entered the find criteria that you want, click Perform Find in the status toolbar,
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.
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. See
Defining field indexing options and Defining calculation fields.
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
To find Type this in the field Examples