Find out number of occurance of Substring within a string

Syntax--
Call OSS(str,substring)


Function OSS(str,sbstring)
occ=split(str,sbstring)
oss=ubound(occ)
End Function

Exp--msgbox OSS("anianianianiani","ani")
Find out number of occurance of Substring within a string Find out number of occurance of Substring within a string Reviewed by Animesh Chatterjee on June 13, 2010 Rating: 5

No comments:

Powered by Blogger.