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
  1. Report Builder functionality differs slightly from 4GL functionality.


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