strings.count_substrings

Supported in:

Rules Search

strings.count_substrings(string_to_search_in, substring_to_count)

Description

When given a string and a substring, returns an int64 of the count of non-overlapping occurrences of the substring within the string.

Param data types

STRING, STRING

Return type

INT

Code samples

This section contains examples that calculate the number of times a substring appears in a given string.

Example 1

This example uses a non-null string and a non-null single substring character.

strings.count_substrings("this`string`has`four`backticks", "`") = 4

Example 2

This example uses a non-null string and a non-null substring greater than one character.

strings.count_substrings("str", "str") = 1

Example 3

This example uses a non-null string and an empty substring.

strings.count_substrings("str", "") = 0

Example 4

This example uses an empty string and a non-null substring greater than one character.

strings.count_substrings("", "str") = 0

Example 5

This example uses an empty string and an empty substring.

strings.count_substrings("", "") = 0

Example 6

This example uses a non-null string and a non-null substring that is greater than one character and greater than one occurrence.

strings.count_substrings("fooABAbarABAbazABA", "AB") = 3

Example 7

This example uses a non-null string and a non-null substring that is greater than one character and greater than one occurrence. It highlights the limitation with overlapping substring occurrences

strings.count_substrings("ABABABA", "ABA") = 2