Progress
Report Builder
User’s Guide


SUBSTRING-COUNT

Returns the number of times a substring occurs within a character expression.

SYNTAX

SUBSTRING-COUNT ( string , substring ) 

string

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

substring

A character expression (a constant, field name, or expression that returns a character value) that is a character substring of string.

EXAMPLE

You might have a 10-character field (Response) that contains the letters Y and N representing yes and no responses to a questionnaire. To count the number of Yes responses, create a calculated field containing this expression:

SUBSTRING-COUNT(Response, "Y") 


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