Working with Data Models › Find and Replace

Find and Replace

You can use the Find and Replace feature to globally search for anything that is exposed in the model (including all string properties) and optionally replace with the text specified. You can use features such as matching case, wild cards, and search direction. This gives modelers the ability to make changes across large models to ensure consistent metadata.

Note: The Find and Replace feature does not replace Find functionality already implemented elsewhere in the program (such as the Model Explorer, Action Log, Bulk Editor, or Complete Compare).

To use the Find and Replace option

1. Click Find on the Edit menu.

   The Find and Replace dialog opens.

2. Enter the text you want to find and select from the following options:

   Match Case

   Searches text 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, macros are expanded first then the match is determined on the expanded value. Table and view names are macros by default, unless they are specifically overridden.

   Wildcard

   Selects 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 direction

   Selects which direction within the model to search the text-- forward or backward. The default is Forward.

   Select the Replace check box if you want to replace the text found, and click Find to start the search.

   If the text is found, it appears below in the Found object and property pane. You can click Replace to replace the text found with the new text in the Replace field.

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

   If the search text is not located, a message states that no matches were found.

3. Click Find Next to repeat the last search you specified and find the next occurrence of the text.

   The next occurrence is selected. The search terminates when it reaches the end of the model. You will be prompted that there are no more matches and if you like to restart the search from the beginning of the model.