OCCURS()

From Lianjapedia
Revision as of 06:41, 4 February 2013 by Helen.george (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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(), SET STRESCAPE, 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", "Lianja DAO Classes for Java")
         4

Products

Lianja, Lianja Server