Crystal Reports for Eclipse Designer Guide

Left (str, length)

Description
Extracts the specified number of characters from the left side of the string.
Arguments
  • str is a text string.
  • length is a whole number indicating the number of characters to be extracted from str.
  • Returns
    String value
    Action
    Extracts the specified number of characters from the left side of the string.
    Typical uses
    Use this function to obtain a certain number of characters from the left end of a text string. For instance, you could use the Left function to obtain just the area code from the values in a field containing phone numbers.
    Examples
    Left("abcdefg", 4)
    Returns "abcd".
    Left({customer.FAX}, 3)
    Retrieves the area code of each fax number when the first three characters of the Fax field contains the area code.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/