16.20 - Finding 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
Use the Find dialog to find specific text strings in the Query window. You may search for strings using regular expressions or wildcard characters in addition to specific text.
  1. Do one of the following:
    • Click .
    • Select Edit > Find.
    • Press Ctrl+F.
  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. Select from the following options:
    • Search Whole word only – Finds text only where a 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
    • Use Regular Expression – Searches for strings that match a regular expression
      Most modern regex flavors support a variant of the regular expression syntax called free-spacing mode. This mode allows for regular expressions that are much easier for people to read. In free-spacing mode, whitespace [spaces and tabs] between regular expression tokens is ignored. White space will not be ignored ‘within’ tokens however, so ‘\ d’ is not the same as ‘\d’, and white space within square brackets is not ignored. If you need to search for a space and/or tab use one of \s, [ ], \x20, \x09.
    • 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
  4. Specify the search direction by selecting Direction up or Direction down.
  5. Click Find Next to locate the string.
    To locate consecutive strings, click Find Next or press F3.
  6. Click Mark All if you want to place a bookmark on each line containing the search string.
  7. Click Close to close the dialog.