Replacing a Text String in the Query Window - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Replacing a Text String in the Query Window

Replace any text string in the Query Window with another.

1 With the Query Window active, do one of the following:

  • From the Query Window toolbar, click .
  • Select Edit > Replace from the menu bar.
  • Press Ctrl+H.
  • 2 Enter the desired text string in the Find what field. If you want to build a regular expression, you can access predefined strings by clicking the solid arrow to the right of this field and selecting the expression you want inserted.

    3 Enter the desired replacement text string in the Replace with field.

    4 Select from the following:

  • Whole word only – finds text only where the whole word matches the search string
  • Match case – finds text that only matches the case of the search string
  • Search selected text only – restricts the search to the currently selected block
  • Search hidden text – searches within hidden [collapsed] text also
  • Regular Expression – searches for strings that match a regular expression
  • Use Wildcards – Allows the use of wildcard characters:
    ? – any single character
    * – any number of characters
    # – any single digit
    [xyz] – any one character in the set
    [!xyz] – any one character not in the set
  • 5 Select from the following:

  • Click Find Next to find and select the string.
  • Click Replace to replace the found string, or to find the next matching string if the string has not yet been found.
  • Click Replace All to replace all strings matching the find criteria.
  • 6 Click Close to close the dialog.