Database Tour Documentation Contents Index

Searching and Replacing Text

Top Previous Next

You can search the text in tables, in report builder (in template), in SQL expressions, in table, field and index lists.

Searching in the report builder

You can search the text among all text objects of the report template. Use the corresponding button or menu item for this.

Searching in the object list

When the object list focused, it is enough to enter first symbols of the table name and press ENTER. Also can be used the corresponding item from the Search menu.

Searching in the field or index lists

You can find a field or index in the list by its name. Follow to the corresponding page and use the corresponding button or the items from the Search menu.

Searching and replacing the text in SQL-expression

You can search / replace the text in SQL expressions (in SQL window, Edit page).

Searching and replacing the text in the table data

There are two search types.

1. Search for the first match in the current column. The search some faster, but it is executed only to the first text that matches the condition.

To search you must enter text to find into the corresponding field right above the table and press ENTER or double click the field. Some quick search options are available through the context menu of the field, where you enter text to find.

Please note that this kind of search has some limitations: for numeric fields, it can search only whole field content, not substrings; for text fields, it can search either whole field content or beginning part of the field only (if the corresponding quick search option turned on).

2. Advanced search. Search some slower, but it has many options and makes possible replacing. This search is available from Search menu.

Before search you must enter text to find (as well as text to replace with, if replace function was called) and select options:

-Search in all fields or search in the selected field only (in the last case it needs to select a field);
-Direction for searching (forward or backward);
-Origin (search in all data set or from the cursor position);
-Option of case sensitivity. If the option is checked then the search is case sensitive.
-Whole words search. If the option is checked then only whole words can be found.
-If you checked Prompt on Replace option, each time the text is found you must agree or disagree to replace it.

After multiple replacing (if you choose Replace All) you will get the total number of replaced text fragments.

Choose Search Again to search the text, which was searched last time, from the cursor position.

In Database Tour Pro, the replacing can be performed also via field utilities in command line.

Note

1. Only those fields, which are compatible with string format, can be used in search. For autoincrement fields only searching can be used, but not replacing.

2. Replacing works only if the data set is editable.

3. Sometimes it may be that not all the text is replaced, when you have chosen Replace All. It happens in the following situations (try to avoid such situations):

-You try to replace the text in the fields, which are used in the current primary index (Paradox tables). The cause of it is changing the text in current primary index field may change the record position.
-In the filtered data sets, if the new text does not satisfy to filter condition. For example, the filter is tax=25 and you wish to replace all the text in the tax field with text, which differ from 25.

See also

 Command Line Usage

 Batch Changing Field Values

 Batch Operations with Text Fields