How to ... Find and Replace

SQL Visualizer allows you to find and replace text within a query.

To invoke the find dialog click the Find toolbar button or press Ctrl-F. When invoked the find dialog's search text will default to what was selected in the editor, or the current word if nothing was selected.

To find the next occurrence of the specified text click the Find Next button, or press F3. The Find dialog allows you to specify whether you wish to match the text exactly or just a partial match, and whether to match case or just match the text irrespective of case. The direction option allows you to search from the current position to the bottom of the document, or from the current position back to the start of the document.

In addition to searching through the text one occurrence at a time you can also bookmark all the occurrences in one go by clicking the Bookmark All button.

By sliding the opacity bar you can make the dialog semi-transparent allowing you to see text under the dialog itself.

To invoke the replace dialog click the Replace toolbar button, press Ctrl-H, or click the Replace menu from the Find dialogs drop down list.

In addition to the features available from the Find dialog you can replace the selected text with the specified text. You can perform the replace one occurrence at a time or replace all occurrences in one go.

N.B. Find and Replace only uses the currently active window, it does not include other open windows.