Progress
Report Builder
User’s Guide


LEFT-TRIM

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

SYNTAX

LEFT-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 be trimmed from string. If you do not specify trim-chars, the LEFT-TRIM function removes spaces, tabs, linefeeds, and carriage returns.

EXAMPLE

To left-justify the page number field (Page) in a document index, create a calculated field containing this expression:

LEFT-TRIM(STRING(Page, "x(5)")) 

Sample data:

Topic               Page
Word truncation     12
Word-wrap            8 


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