User manual

30 FileMaker Pro User’s Guide
Finding and replacing data
As in a word processing application, you can find and replace data
across multiple fields (including related fields) in a record or in a find
request, across a found set of records or find requests, or across text
objects in a layout. You can search for data in any type of field except
container fields and fields that are not modifiable.
1. In Browse, Find, or Layout mode, choose
Edit menu > Find/Replace > Find/Replace.
2. In the Find what box, type the data you want to search for. In the
Replace with box, type the replacement data.
You can’t replace data in fields that are formatted as pop-up menus,
radio buttons, or checkboxes. These fields will be counted and
reported as skipped at the end of a
Replace all operation.
3. Set the search options you want to use.
4. Click one of the buttons to perform the type of find/replace
operation you want.
For more information about finding and replacing data, see Help.
Sorting records
FileMaker Pro stores records in the order they were added to the file.
Sorting temporarily rearranges records, so you can view, update, or
print them in a different sequence.
You choose the fields whose contents you want to sort by. The first
sort field arranges the records based on the field’s contents. The
second sort field arranges records when two or more records have the
same value in the first sort field, and so on. You can sort records in
ascending order, descending order, or in a custom order.
Select To
An option from the
Direction list
Choose the search direction: Forward, Backward, or All.
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.
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 just 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.
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 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 and replaced.
Select To