You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 13
Next »
returns the number of coinciding positions of a sub string in a string
Syntax
![](/plugins/servlet/confluence/placeholder/unknown-macro?name=span&locale=en_GB&version=2)
Arguments
- Pos% is optional and a numeric expression that sets the starting position for each search. If omitted, search begins at the first character position.
- Search$ is required and a string expression being searched.
- Pattern$ is required and a string expression sought in the search string.
Examples
![](/plugins/servlet/confluence/placeholder/unknown-macro?name=span&locale=en_GB&version=2)
returns 0
![](/plugins/servlet/confluence/placeholder/unknown-macro?name=span&locale=en_GB&version=2)
returns 11
![](/plugins/servlet/confluence/placeholder/unknown-macro?name=span&locale=en_GB&version=2)
returns 0
Quick links: INSTR