Difference between revisions of "OCCURS()"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 30: Line 30:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:String Data]]
 +
[[Category:String Data Functions]]

Revision as of 15:57, 2 June 2009

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