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