Progress
Report Builder
User’s Guide
SUBSTRING-COUNT
Returns the number of times a substring occurs within a character expression.
SYNTAX
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.
EXAMPLEYou 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:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |