Progress
Report Builder
User’s Guide
RIGHT-TRIM
Removes trailing white space, or other specified characters, from a character string.
SYNTAX
string
A character expression (a constant, field name, or expression that results in a character value).
trim-chars
A character expression that specifies the characters to trim from string. If you do not specify trim-chars, the RIGHT-TRIM function removes spaces, tabs, linefeeds, and carriage returns.
EXAMPLEIn the Customer table, to print the state next to the city with only a comma and one space between the two fields, create a calculated field containing this expression:
The Report Builder prints the field as follows:
You can also use the concatenation operator (-) to do the same thing using this expression:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |