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.
Back to top
Red Hat logoGithubredditYoutubeTwitter

Learn

Try, buy, & sell

Communities

About Red Hat Documentation

We help Red Hat users innovate and achieve their goals with our products and services with content they can trust. Explore our recent updates.

Making open source more inclusive

Red Hat is committed to replacing problematic language in our code, documentation, and web properties. For more details, see the Red Hat Blog.

About Red Hat

We deliver hardened solutions that make it easier for enterprises to work across platforms and environments, from the core datacenter to the network edge.

Theme

© 2025 Red Hat