occurs() function

The occurs() function searches a string for attributes or values that occur consecutively.

Syntax

occurs(str.exp, num.exp)

Parameter(s)

str.exp String to search.
num.exp Numeric expression that specifies the number of occurrences.

Description

This function returns all substrings that occur at least the number of times specified by num.exp, delimited by the same mark as in the string.

Example(s)

The ] represents a value mark.

string = ’22]11]11]11]22]11]11]22]11]11’

for n = 1 to 5
substr=occurs(string,n)
print n ’r%2’ : ’ ’: substr
print dcount(substr,@vm):’ string(s) occurring ’:n:’ time(s)’
next n

This code outputs:

01 22]11]22]11]22]11 6 strings occurring 1 time.
02 11]11]11 3 strings occurring 2 times.
03 11 1 string occurring 3 times.
04 0 strings occurring 4 times.
05 0 strings occurring 5 times.

The output for line 01 is each time string is found at least once in a series. On line 02, the substring 11 is found to occur in a series of 2 at least twice in the major string. The string 11 is also found in a series of 3 one time. No 4 or 5 repetitive series are found.