Getting Started › Find and Replace

Find and Replace

You can locate entries in the Model Explorer using the Find and Replace feature. The Locate in Model Explorer and the Locate in Diagram options help you locate objects using their name as displayed in the Model Explorer.

Use the Find and Replace feature to search for anything that is exposed in the model (including string properties) and replace with the text specified. From release r9.6 onward, you can search for the Extended Notes.

This feature helps you change across large models to ensure consistent metadata.

Note: The Find and Replace feature does not replace the Find functionality that is already implemented elsewhere in the program. The Find functionality is available in the Model Explorer, Action Log, Bulk Editor, and Complete Compare dialogs.

Follow these steps:

1. Click Find either on the Edit menu or in the Model Explorer.

   The Find and Replace dialog opens.

2. Work with the following options:

   Find what

   Specifies the text that you want to find.

   Replace with

   Specifies the text that replaces the text that is found. Select the check box to enable the option and enter the replacement text. Click Replace to replace the text found with the new text in the Replace with field.

   Match case

   Searches text that is based on case. When cleared, the case is ignored to determine match.

   Match whole word

   Searches for the entire text string to determine match.

   Match against expanded values

   When selected, expands the macros first and then determines the match on the expanded value. Table and view names are macros by default, unless they are overridden.

   Match only against name

   Searches for match based only on the name of an object. This option is selected by default when you use the Find and Replace feature in the Model Explorer.

   Wildcard

   Selects the DOS or SQL wildcards to determine match. For example, use the asterisk (*) wildcard to search for a string of characters ("c*r" finds "customer" and "car").

   Search

   Specifies the direction within the model to search the text--forward or backward.

   Default: Forward

   If the text is found, it appears in the Found object and property pane. If you use the Find and Replace feature from the Model Explorer, the search results are restricted to the objects available in the model.

   Note: If the property is not marked as Read-only, you can also directly edit the text in the Found object and property pane. If you edit the text in the property pane and click Replace, then the edited text is used as the replacement text.

   Found object and property

   Displays the details of the text that the search has found. Use the following options to go to the corresponding object:

   Locate in Model Explorer

   Locates the search text (object) in the Model Explorer and highlights it.

   Locate in Diagram

   Locates the search text (object) in the current diagram and highlights it.

   Note: If you are using the Find and Replace feature in the Model Explorer, then the Locate in Diagram option is not available. If the object you have searched for is not available in the current diagram, the Locate in Diagram option is unavailable.

3. Click Find Next.

   The next occurrence of the search text is selected. The search terminates when it reaches the end of the model.