Post History

@elgonzo mentioned correctly that the nice trick from @pnuts can not be applied if you are interested in the number of occurrences including overlapping ones.

So, just in case someone is in need of such a functionality, here is a function in LibreOffice Basic which handles that case:

```
Function countOccurrences(searchedWithin As String, searchedFor As String) As Long
Dim count As Long
Dim foundPos As Long
    count = -1   ' Will become 0 on loop entry and then 1 if really found the first time
    foundPos = 0 ' Will cause search to start at 1 in first loop iteration
    Do
        count = count + 1
        foundPos = Instr(foundPos + 1, searchedWithin, searchedFor, 0)
    Loop While foundPos > 0
    countOccurrences = count
End Function
```