Show Table of Contents
2.38. String Manipulation on Input Data
The CSV and fixed-length readers allow you to execute string manipulation functions on the input data before the data is converted into SAX events. The following functions are available:
- upper_case: this returns the upper case version of the string.
- lower_case: this returns the lower case version of the string.
- cap_first: this returns the string with the very first word capitalized.
- uncap_first: this returns the string with the very first word un-capitalized. It is the opposite of cap_first.
- capitalize: this returns the string with all words capitalized.
- trim: this returns the string without leading and trailing white-spaces.
- left_trim: this returns the string without leading white-spaces.
- right_trim: this returns the string without trailing white-spaces.
You can chain functions via the point separator. Here is an example:
trim.upper_case
How you define the functions per field depends on the reader you are using.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.