Frequency

Checks how many items in an ANStr
ANStr is list of items separated by a seperator
like "Item1||Item2||Item3||Item4"

CodeFunctionName
What is this?

Public

Tested

Original Work
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

TheString, TheSep

Views 4,750

Downloads 1,362

CodeID
DB ID