Crystal Reports for Eclipse Designer Guide

TrimRight (str)

TrimRight and RTrim (str) are equivalent functions.
Description
TrimRight removes all spaces to the right of a string or data field which is stored left-justified in a database.
Arguments
  • str is a text string.
  • Returns
    String value
    Action
    TrimRight removes all spaces to the right of a string or data field which is stored left-justified in a database.
    Typical uses
  • Use this function any time there are trailing blanks in a text object that may interfere with an alignment of text strings, a character count, or with a calculation (if the string is eventually converted to a Number).
  • Use whenever you combine (concatenate) justified text strings and want to have the proper spacing between strings.
  • Examples
    TrimRight("Al/4520/B12    ")
    Returns "A1/4520/B12".
    TrimRight({file.REFERENCE})
    Returns "Bal Fwd." where the text string "Bal Fwd.    " is left-justified in the field.



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