MicroStrategy ONE

Find/Replace dialog box

The Find/Replace dialog box allows you to search your Command Manager scripts, which provides the following benefits:

  • You can find specific strings of characters in your scripts.

  • You can replace strings of characters you find in your scripts with different strings of characters. This allows you to make updates to your scripts such as the name change of a user or group.

This dialog box allows you to search for and replace strings of characters using the following options:

  • Find What: Type or select the string of characters to search your scripts for. Recent searches are saved and can be selected from this drop-down list.

  • Replace With: Type or select the string of characters to replace the string of characters found in the search of a script. Recent strings used for replacement purposes are saved and can be selected from this drop-down list.

  • Search: In this area, select whether to search the current script or all open scripts:

    • Current Script: Select this option to only search the selected script.

    • All Scripts: Select this option to search all the queries that are currently open.

  • Find Whole Word Only: Select this check box to search for specific words. If the string of characters is part of a word that has additional characters, selecting this option skips over these occurrences when performing a search.

    For example, you have a script that refers to both ATTRIBUTE and ATTRIBUTEFORM.  To only find ATTRIBUTE and not ATTRIBUTEFORM, search for ATTRIBUTE and select the Find Whole Word Only check box.

  • Match Case: Select this check box to make the search case-sensitive.

  • Regular Expression: Select this check box to search for strings of characters using regular expressions. A regular expression allows you to use various operators to search for words using different patterns.

    For example, you can select the Regular Expression check box and type DBCONNECTION|DBCONN. The pipe operator (|) acts as a logical or-type of operator. This type of search will find all occurrences of DBCONNECTION as well as DBCONN.

  • Find Next: Find the next occurrence of the search criteria.

  • Cancel: Close the Find/Replace dialog box.

  • Replace: Replace the selected characters with the characters provided in the Replace With drop-down list.

  • Replace All: Replace all occurrences of the search criteria with the characters provided in the Replace With drop-down list.

Related Topics

Editing a script

Script window