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
