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
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
' 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 143
Downloads 72
CodeID
DB ID
ANmarAmdeen
610
Revisions
v1.0
Saturday
December
16
2023