Database Tour Documentation Contents Index

Batch Operations with Text Fields

Top Previous Next

These functions are executed on the entire contents of string field(s) of active data set (data set must be editable):

Change Text Case Change field text either to uppercase or to lowercase
First to Upper Case Convert the first character in the field text to uppercase
Capitalize Convert the first characters of each word in the field text to uppercase
Trim Trim the field text of leading and trailing spaces and control characters
Add Prefix Add a prefix to the field text
Add Suffix Add a suffix to the field text
Replace Text Replace the specified fragments in the field text with replacement text

Activate these functions by double-clicking the corresponding column or by choosing Tools | Batch Operations with Text Fields.

In Database Tour Pro, these functions can be performed also via command line.

See also

 Command Line Usage

 Searching and Replacing Text

 Batch Changing Field Values