Progress
Report Builder
User’s Guide
TRIM
Removes leading and trailing white space, or other specified characters, from a character string.
SYNTAX
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.
EXAMPLETo remove leading and trailing punctuation marks and spaces from a sentence, use the following expression:
Sample data:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |