Database Tour provides an interface to perform some useful operations with text fields of active dataset. Activate these functions by double-clicking the corresponding text column or by choosing Tools | Batch Operations with Text Fields....
Note: These operations can also be performed from command line or action file.
Descriptions of Options
Change Text Case
Change field text either to uppercase or to lowercase. Command line equivalent: /ToUpper, /ToLower.
First to Upper Case
Convert the first character in the field text to uppercase. Command line equivalent: /FirstToUpper.
Capitalize
Convert the first characters of each word in the field text to uppercase. Command line equivalent: /Capitalize.
Trim
Trim leading and trailing spaces from the field text. Command line equivalent: /Trim.
Add Prefix
Add a prefix to the field text. Command line equivalent: /AddPrefix.
Add Suffix
Add a suffix to the field text. Command line equivalent: /AddSuffix.
Replace Text
Replace the specified fragments in the field text with replacement text. Command line equivalent: /ReplaceText, /ReplaceWith, /ReplaceIgnoreCase.
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
Command Line for Performing Batch Operations with Text Fields