Using character functions

Character functions can be applied mainly on character objects (non-numeric or date objects), but they can also be used to convert a date or numeric object into a string (character type) object.

Character functions are mainly used to manipulate string objects.

For example, we might want to combine two string objects into one, such as a customer's first and last name, return just part of the string, and so on.

The main character functions are as follows:

  • Left: This returns the leftmost character in a string
  • Right: This returns the rightmost character
  • Concatenation: This combines two character strings
  • Match: This searches for a specific character or a combination of characters inside a string
  • Replace: This replaces a character ...

Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.