Loop through all occurrences of a string within a string

Hi guys,

with a web request (MSXML2.XMLHTTP) I pull a responsetext of a website.
This responsetext has several occurrences of the string " shops", which comes with a number in front of it.

So for example

"1 shops"
"12 shops"
"3 shops"

These quantities of shops are not in order, so basically what I want to do is loop through the occurences, find the one with the highest quantity and go from there (I'll grab a link after that from the same responsetext, based on the location of that "x shops" I found to be the highest)

What's the best way to go about it? Just "inStr" or "inStrRev" wouldn't only show me the first and last occurrence - so what's the best way to go through all?
I was considering to do "x = Instr(responsetext, x, " shops")" and then x = x + 1, loop until there's no x anymore.
But that doesn't sound very easy, so was wondering if someone can help me do this more efficiently.

Thanks!

the INSTR function has a start position argument.

Please Login or Register  to view this content.

Hi Andy,

thanks for your reply - this will probably work (I didn't test it yet), but I was looking for something simple actually
I am now using an approach by splitting the string with delimiter " shops" and loop from 0 to ubound variable checking the last few characters of each split (cause if I split "12 shops" with delimiter " shops"), the final characters of the part before the splut will be "12", so I thought this is the easiest way).

Please Login or Register  to view this content.