Database Tour provides an interface to perform some useful operations with text fields of active dataset. Activate these functions by double-clicking the corresponding column or by choosing Tools | Batch Operations with Text Fields....
Descriptions of Options
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 |
Notes
- The dataset must be editable.
- For large datasets it is recommended to use SQL means instead, if possible.
- In Database Tour Pro, these functions can be performed also via command line.
See also