Finding 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

Finding a Text String in the Query Window

You can find specific text strings in the Query Window using the Find dialog. You may search for strings using regular expressions or wildcard characters in addition to specific text.

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

  • On the toolbar, click .
  • Select Edit > Find from the menu bar.
  • Press Ctrl+F.
  • 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 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
  • Note: 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 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.