Checks how many items in an ANStr
ANStr is list of items separated by a seperator
like "Item1||Item2||Item3||Item4"
Function Frequency(TheString, TheSep)
' Counts how many Items found in string with seperator, seperator can be any string, or char
' TheString="Esum+ColID+ColID"
' TheSep="+"
Frequency = (Len(TheString)-Len(Replace(TheString,TheSep,""))) / (Len(TheSep)) + 1
End Function
' Counts how many Items found in string with seperator, seperator can be any string, or char
' TheString="Esum+ColID+ColID"
' TheSep="+"
Frequency = (Len(TheString)-Len(Replace(TheString,TheSep,""))) / (Len(TheSep)) + 1
End Function
TheString, TheSep
Views 4,755
Downloads 1,364
CodeID
DB ID
ANmarAmdeen
610
Revisions
v1.0
Friday
June
8
2018