Difference between revisions of "OCCURS()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the number of times a specified character expression occurs within another specified character expression.
 
Function to return the number of times a specified character expression occurs within another specified character expression.
Line 25: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]

Revision as of 17:29, 3 December 2009

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, Recital Server