Counting the occurence of a string ...

Hi ...
I have a weblog database where I want to count the occurences of a
table of string values that appear in all the urls viewed.

My tblWebLog as a field that contains the url ...
tblWebLog.[cs-uri-stem]

I have another table ... tblStrings ... that has a field [strSearch]
for a string value and an integer field [intViewCount] to count the
occurence of the string in tblWebLog.[cs-uri-stem]

I've been trying ...

Update tblStrings
Set [intViewCount] = (Select Count(*) From tblWebLog Where
[cs-uri-stem] Like '%_' + tblStrings.[strSearch] + '.htm%')

.... but it doesn't fly and I'm stumped. Any thoughts?

Cheers.

.

Relevant Pages

  • Re: # of occurences of string in another string
    ... int index = 0; ... That should get you the number of occurences correctly. ... > I wrote something a while back that stores the offset of all string> occurences within another string. ... Is there an easier/faster way to do>> it using regular expressions? ...
    (microsoft.public.dotnet.languages.csharp)
  • String matching from dictionary in very large text
    ... I am working on one informatics problem and I am ... curious if it is possible to find all occurences of every word from a ... 5000-10000 each in text with length 5MB (the text is simply a string ... 1,4GHz Athlon, but it was incredibly slow for 5MB). ...
    (comp.programming)
  • Re: String search vs regexp search
    ... of occurences using string & regexp. ... I wrote the code for the regexp search as well as the function ... How long is the substring? ...
    (comp.lang.python)
  • Re: Searching from right - code mod please!
    ... Not sure that helps with the issue of no third forward slash. ... Function RAT(strSearchIn As String, _ ... If occurences>= 0 And _ ... Dim aSearchInAs Byte, intCounter As Integer, bytSearchFor As ...
    (microsoft.public.access.macros)
  • Re: Function to replace multiple occurence of substring in a string
    ... > replace all occurences of a substring in a string. ... What code do you have so far, and how does it fail when you try ... > It should take care of multiple occurences of the substring... ...
    (comp.lang.c)