Frequency1

Finds how many a string found inside larger string.
Similar to Frequency but not much. Frequency will assume a separator and then finds how many items found inside string assuming separator. Frequency1 does not care about separators. It just searches for string inside another and return how many times found.
Frequency returns 1 as min value, it will never return 0
Frequency1 can return 0 if none found

CodeFunctionName
What is this?

Public

Tested

Original Work
Function Frequency1(OfText, InText)
    ' Not like frequency
    ' Frequency does separator, this one does actual search
    ' Frequency returns 1 as min value, it will never return 0
    ' Frequency1 can return 0 if none found
    Rett = Len(InText) - Len(Replace(InText, OfText, ""))
    Frequency1 = Rett
End Function

OfText, InText

Views 182

Downloads 99

CodeID
DB ID