The Search & Replace function is used to locate records matching Search criteria and replace information in specified fields with new information.
To use Search & Replace
***Always make a Backup copy of the database files before using this function.***
- Select the appropriate database.
- Select Search & Replace from the Find menu to display the Search screen (the first of two screens used by the Search & Replace function). The Search screen looks like a Database record, but all of the fields are blank and the word "Search" is displayed in the lower right corner of the screen.
- Enter the Search criteria in the appropriate fields. Search Operators may be used with the search criteria. Search criteria may be entered in as many fields as necessary. Select the Lookup List button (or press [Ins] or [F2]) to display a list of the currently available options for a field (if options are available for that field).
- Press [F10] or [PageDown] to display the Replace screen (the second of two screens used by the Search & Replace function). The Replace screen looks like a Database record, but all of the fields are blank and the word "Replace" is displayed in the lower right corner of the screen.
- Enter the replacement information into any field or combination of fields (including fields that contained the Search criteria if necessary).
- Press [F10] or [PageDown] to begin the Search.
- When the Search locates the first record that matches all of the Search criteria, a prompt is displayed asking to Confirm changes to each record. Yes is the recommended answer. The first record matching the Search criteria is displayed and the "Update this record (Yes/No/All)" prompt is displayed at lower left corner of the screen.
- Select Yes to update the record and continue to the next record that satisfies the Search criteria.
- Select No to not update the record and continue to the next record that satisfies the Search criteria.
- Select All to update the record and continue updating all the records that satisfy the Search criteria without prompting for confirmation.
***Always make a Backup copy of the database files before using this function.***
Note: This function can wipe out much or even all database record information.
See:
Special Search Operator Characters
Search & Replace Replacement Formulas
Database Manager Contents