Progress
Report Builder
User’s Guide


TRIM

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

SYNTAX

TRIM ( string [ , trim-chars ] ) 

string

A character expression (a constant, field name, or expression that returns a character value).

trim-chars

A character expression that specifies the characters to trim from string. If you do not specify trim-chars, the TRIM function removes spaces, tabs, linefeeds, and carriage returns.

EXAMPLE

To remove leading and trailing punctuation marks and spaces from a sentence, use the following expression:

TRIM(sentence, " .!?" 

Sample data:

Sentence                    TRIM(sentence, " .!?"
     This is a test.        This is a test
Is anyone out there?!       Is anyone out there
HELLO!!!!!!                 HELLO 


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