Thanks to all that responded. i ended using this function which counts the amount of delimeters. after getting the results i just counted the rows.
Function xg_GetSubString(mainstr As String, n As Integer, delimiter As String) As String
'* Get the "n"-th substring from...
Thanks for the reply. Each record is one very long string ie: "W|W|UEPBX|3|23799|mike|Non-Designed|mike|NDS-SB|No" I
am trying to get a total count of "mikes" in the column.
I have been trying to create a function that will do it but have been at a loss..
I need help!! I have a table in which im trying to find the count of a string in a specific column. In other words, im trying to count how many times "mike" shows up in a specific column.Can anyone help!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.