The occurs() function searches a string for attributes or values that occur consecutively.
occurs(str.exp, num.exp)
| str.exp | String to search. |
| num.exp | Numeric expression that specifies the number of occurrences. |
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.
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.