Crystal Reports for Eclipse Designer Guide

ProperCase(str)

Description
ProperCase capitalizes the first letter of each word in the string and converts all other letters to lower case.
Arguments
  • str is a text string.
  • Returns
    String value
    Action
    ProperCase capitalizes the first letter of each word in the string and converts all other letters to lower case. It also capitalizes any letter that follows a non-alpha character.
    This function is particularly useful for capitalizing people's names correctly when they are stored as all capitals in a database.
    Examples
    ProperCase ("LINDA FONG")
    This example will return "Linda Fong".
    ProperCase ("123Michael's")
    This example will return "123Michael'S".
    Comments
    This function is similar to the "Proper" function in Excel.



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