OCCURRENCES

Returns the count of occurrences of the needle in the haystack. This function is case sensitive.

OCCURRENCES(haystack, needle)

Parameters

• haystack - The string input (the haystack).
• needle - The string to be found (the needle).

Examples

OCCURRENCES("ABCDEFG ABC", "B")

Result: 2