Progress
Report Builder
User’s Guide


RIGHT-TRIM

Removes trailing white space, or other specified characters, from a character string.

SYNTAX

RIGHT-TRIM ( string [ , trim-chars ] ) 

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.

EXAMPLE

In 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:

RIGHT-TRIM(City) + ",  " +  State 

The Report Builder prints the field as follows:

Detroit, MI
Columbia,MO
Portland,OR 

You can also use the concatenation operator (-) to do the same thing using this expression:

City - ",  " +  State 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095