OCCURS()

Class

String Data

Purpose

Function to return the number of times a specified character expression occurs within another specified character expression.

Syntax

OCCURS(<expC1>,<expC2>)

See Also

AT(), ATNEXT(), INLIST(), LEFT(), RAT(), RIGHT(), STR(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The OCCURS() function returns the number of times the character expression <expC1> is found in character expression <expC2>. A value of zero is returned if <expC1> does not exist in <expC2>. The character matching is case sensitive.

Example

? occurs("a", "Recital DAO Classes for Java")
         4

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer