Finding a Text String in the History Table - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Finding a Text String in the History Table

You can find a specific text string in the History Table.

To find text in the history grid

1 With the history table window active, select Edit > Find.

2 Complete the following options:

 

Table 31: Find Dialog Box 

Option

Description

Find What

Enter the desired text string, or select an existing text string .

Match Case

Select this checkbox to find text that matches the case of the search string.

Search current column only

Clear this check box to search the entire spreadsheet. If multiple cells are selected, the ‘current’ cell is marked with a bold outline.

The default is selected, but the new setting is retained if it is changed.

Note: Searches are faster when they are limited to a single column.

Use wildcard characters ( * and ?)

Select this checkbox to treat any question mark symbol (?) and asterisk symbol (*) in the search string as a “wildcard” character.

The question mark represents any single character. The asterisk represents any string of zero or more characters.

Find Next

Click to search for the next occurrence of the search string within the current grid. The search starts at the current cell position in the grid.

Find All

Click to find all occurrences of the search string and display them in a listbox. Clicking an item in the list moves the selection in Answerset to the corresponding cell. The cell appears if necessary.