Crystal Reports for Eclipse Designer Guide

Len (str)

Len and Length (str) are equivalent functions.
Description
Len returns a Number indicating the length of the given string.
Arguments
  • str is a text string.
  • Returns
    Whole number
    Action
    Len returns a Number indicating the length of the given string.
    Text strings must be enclosed in quotation marks. Any blank spaces are included as part of the character count.
    Typical use
    Use this function any time you have a manipulation, comparison, or calculation that is dependent on the length of a text string.
    Examples
    Len("Account")
    Returns 7.
    Len("Text String")
    Returns 11. The blank space between "Text" and "String" is counted as a character.
    Len("  Center  ")
    Returns 10. There are 2 spaces on either side of the word "Center".
    Len(ToText({orders.ORDER AMOUNT}))
    Returns 9, where {orders.ORDER AMOUNT} is 14233.08, and ToText ({orders.ORDER AMOUNT}) returns the String "14,233.08". Here, the comma and period have been specified in the Number format for the formula field as the thousands and decimal separators respectively.
    Len(ToText({orders.ORDER AMOUNT}, 2, "", "."))
    Returns 8 where {orders.ORDER AMOUNT} = 14233.08, and ToText ({orders.ORDER AMOUNT}, 2, "", ".") returns the String "14233.08". Here, the null character and period have been specified in the Number format for the formula field as the thousands and decimal separators respectively.
    Len({customer.CUSTOMER NAME})
    The length of the text string stored as a value in {customer.CUSTOMER NAME}.



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