Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 132
• FileMaker Pro automatically updates sort order in a file when:
• you make changes to related fields specified in the sort order. However, only the current
parent record is affected.
• any schema change, a local import-record operation, a local operation that replaces the
contents of a field, a local field relookup, a local ODBC operation, or a redefined
external data source modifies records in a table.
• FileMaker Pro does not automatically maintain sort order for modifications to:
• records that are not related to the current record.
• related fields. For example, when you sort in Table view on a related field and then
create a blank record, the record remains at the bottom of the sorted records instead of
sorting to the top with other blank records.
• a value list that is included in a sort order.
• external ODBC data sources.
Records disappear after sorting
• Records with nothing in the sort field sort to the top of the list in an ascending sort. Scroll
down (or click the book icon to page down) to see your records or omit blank records before
sorting.
Sorting repeating fields
• You can't sort the values within a repeating field.
• Repeating fields sort according to the value in the first repetition.
Related topics
Sorting records
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.
To find and replace data:
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.
Tip To find or replace invisible characters, such as tabs or carriage returns, manually copy and
paste these characters from a field into the Find what or Replace with box.
3. Set the search options you want to use.
Select To
An option from the Direction
list
Choose the search direction: Forward, Backward, or All.