Replacing a Text String in the Query Window - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Teradata SQL Assistant
Release Number
October 2018
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
  1. Do one of the following:
    • Click .
    • Select Edit > Replace.
    • Press Ctrl+H.
  2. In Find what, enter the desired text string. 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. In Replace with, enter the desired replacement text string.
  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.