Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 133
4. Click one of the buttons to perform the type of find/replace operation you want.
Note Some data cannot be found or replaced:
• You cannot find data in container fields. You can find but not replace data in calculation
fields.
Match case Search for only those occurrences in which the capitalization
matches the data you specified in the Find what box.
Note In files that contain Japanese data, a find with the Match
case option cleared does not simultaneously find both the half-
width and full-width version of the same character. To
comprehensively find and replace both characters, make sure you
perform separate finds for both the half-width and full-width
character.
Match whole words only Search for only those occurrences that are whole words or are
bounded by spaces and/or punctuation characters.
Examples
good finds good and good within good-bye
travel finds travel and travel within travel.com but .com does
not find travel.com
stone house[space] finds stone house in the sentence “The
old stone house[space][space]has a large garden,” but does not
find stone house in the sentence “The old stone house[space]has
a large garden.”
An option in Search across In Browse mode, search across all records in the current layout or
just in the current record.
In Find mode, search across all find requests in the current layout
or just in the current find request.
Note In Layout mode, FileMaker Pro searches only in the current
layout.
An option in Search within In Browse and Find modes, search within all fields in the current
layout or just in the current field.
Select To
Click To
Find Next Search for and select the next occurrence of the Find what data.
Replace & Find If there is selected data that matches the Find what data, replace the Find
what data with the Replace with data, search for and select the next
occurrence.
If there is no selected data that matches the Find what data, search for and
select the first occurrence of the Find what data.
Replace Replace the selected Find what data with the Replace with data.
Replace All Replace all occurrences of the Find what data with the Replace with data.
At the end of the Replace All operation, you see a summary of the number of
occurrences found, replaced, and skipped.