Splits the source string into elements separated by separator and returns the number of elements within input source string.

The following table lists the valid parameters:

Examples

If the separator is an empty string, each unicode character in the source string is regarded as an element. The element_count function returns the number of elements (or count) only:

The element_count function returns 0 if both the source string and the separator are empty strings.

The element_count function returns NULL if and only if any argument is NULL.