Edit > Find and Replace (select from Database Table Menu or apply Crtl+H Keyboard Shortcut Key)
Find and replace search phrase.
This operation finds in the database table(s), a search phrase (as specified in the Find input box of the Find Data box) and replaces it with a specified Replace phrase:
Only textual and integer search phrases are supported. You can specify in which Tables and Fields to search. Other settings include Match Case, Match whole word, Zoom to object (when located) and Initially zoom all (to get a better overview of the search result).
The Find Next button can be clicked to obtain the next search result (Previous button the previous search result). Find All can be clicked to obtain all search results at once. The Replace button can be clicked to replace the found search phrase with the specified replace phrase. The Replace All button can be clicked to replace automatically all matching search phrases with the specified replace phrase.
Note, if you access this function when a cell or whole column is selected, a reduced version of the Find Data box will appear - with only the relevant settings available to conduct a search and replace on the current field. You can, however, click the Collapse icon (as indicated above) to revert back to the full functionality.
See Also