countof

Counts the number of non-overlapping occurrences of a substring within a string.

Spec

countof(source, search)

Parameters

source - The string to search in.
search - The substring to count.

Return Value

An int64: the number of non-overlapping occurrences.

Example

datatable(val:string)["banana"]
| extend result = countof(val, "an")

val	result
banana	2