From: rickNOSPAMnews@NOSPAMcomcast.net   
      
   > >> Is there a string function that returns the number of times   
   > >> string a occurs in string b?   
   > >   
   > >Not directly, but there is simple code to do that...   
   > >   
   > >OccurrenceCount = UBound(Split(StringB, StringA))   
   > >   
   > >There are optional argument to the Split, one of which will allow you   
   to   
   > >make the "search" case insensitive if you need that.   
   >   
   > Rick, that is disgraceful advice   
   > Physically splitting a String into an Array just to count instances of   
   > a substring is incredibly inefficient   
      
   If the Split function call is going to be used in a large loop, over and   
   over again, then yes, it would not be advisable (Split is definitely   
   slower than other options). However, counting the number of times one   
   string occurs inside of another is not something you normally do more   
   than once for a given string and sub-string (so I wouldn't characterize   
   using it as "incredibly inefficient" in this case). Given that, I think   
   a user would be hard pressed to see the time differential between using   
   the code I suggested and any other method one might offer (we are   
   talking a small amount of milli-seconds here).   
      
   Rick - MVP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)