How can I search and replace a string in Lotus Notes column formulas?

First make sure viewEZ is running. If it's not, select any Lotus Notes database (email, personal address book, application etc.) on your workspace, and click the viewEZ icon on your Lotus Notes client toolbar.

1. In the first viewEZ window, select the design elements you want to examine using the checkboxes.
2. Click the Columns... button and the Columns window opens with all your database columns displayed and organized by design element.
3. Select the column(s) that you want to act upon for the search and replace. Hold Ctrl or Shift while clicking will help you select multiple columns.
4. Click the menu item, Search > Replace in in Column Formulas... to open the Replacement by regular expression window. Click here for regular expression resource

5. Type in the string to search for and the string that will replace it. Click OK. (Note: You can also use regular expressions to make replacements)