Progress
Report Builder
User’s Guide
String-manipulation Functions
Table B–4 lists the functions that allow you to manipulate strings.
Table B–4: String-manipulation Functions
Syntax Input Data Output Data In
4GL ASC ( expression ) C N![]()
CAPS ( expression ) C C![]()
CHR ( expression ) N C![]()
ENTRY (element, list [, character ] ) N, C, C C![]()
FILL ( expression, repeats ) C, N C![]()
FLIP ( string, delimiter ) C, C C – INDEX ( source , target [ , starting ] ) C, C, N N![]()
INDEX-NTH ( source , target , occurrence ) C, C, N N – INITIAL-CAPS ( string [ , delimiter ] ) C, C C – IS-LETTER ( string ) C L – IS-LOWER ( string ) C L – IS-UPPER ( string ) C L – LC ( string ) C C![]()
LEFT-TRIM ( string [ , trim-chars ] ) C, C C![]()
LENGTH ( string )1 C N![]()
LOOKUP ( expression , list [ , character ] ) C, C, C N![]()
NUM-ENTRIES ( list [ , character ] ) C, C N![]()
R-INDEX ( source , target [ , starting ] ) C, C, N N![]()
REPLACE ( source-string, from-string, to-string ) C, C, C C![]()
REPLACE-INDEXED ( source, start, length,
replace-string ) C, N, N, C C – RIGHT-TRIM ( string [ , trim-chars ] ) C, C C![]()
SPACE ( n ) N C – STRING ( source [ , format ] ) 1 I, C C![]()
SUBSTRING ( source , starting , [ , length ] ) 1 C, N, N C![]()
SUBSTRING-COUNT ( substring, string ) C, C N – TRIM ( string [ , trim-chars ] ) C, C C![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |