SubStringCount - script and chart function

SubStringCount() returns the number of occurrences of the specified substring in the input string text. If there is no match, 0 is returned.

Syntax:

SubStringCount(text, sub_string)

Return data type: integer

Arguments:

Argument	Description
text	The original string.
sub_string	A string which may occur one or more times within the input string text.

Example	Result
SubStringCount ( 'abcdefgcdxyz', 'cd' )	Returns '2'
SubStringCount ( 'abcdefgcdxyz', 'dc' )	Returns '0'

T1:
Load *, 
substringcount(upper(Strings),'AB') as SubStringCount_AB;
Load * inline [
Strings
ABC:DEF:GHI:AB:CD:EF:GH
aB/cd/ef/gh/Abc/abandoned ];

Result

Strings	SubStringCount_AB
aB/cd/ef/gh/Abc/abandoned	3
ABC:DEF:GHI:AB:CD:EF:GH	2

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!