Need a primer on how to process strings in VBA
Posted on 2005-04-19
I guess there must be numerous ways to compare strings,
extract pieces from strings, find substrings in larger strings
and much more.
I would like to understand some of the commonly used methods
in string processing.
That said, let's look at some real data:
A string coud be:
<a href=/cgi-bin/dispGeneModel?db=chlre2&id=162259>162259 </a>
One nice thing would be ways of how to find this string on a webpage (also present As String)
Then a way to extract the number 162259
And last but not least to get rid of unneccessary whitespaces.