OCCURS()

OCCURS() counts the number of times a character string occurs within another character string.

You could use OCCURS(), for example, to find out how many times “New York” occurs in an address field.

Function Format

OCCURS(C1,C2)

OCCURS() returns the number of times string C2 occurs in string C1. All comparisons are case-sensitive.

Examples

OCCURS("abc/abc/a","ab") = 2

OCCURS("abc/abc/a","a") = 3