View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
 
Posts: 391
Default Matching/Finding/Search Array Element

Actually:

StartPosInStr: 2 + StrLength: 1 or Positions 2-2
StartPosInStr: 25 + StrLength: 1 or Positions 25-25
StartPosInStr: 37 + StrLength: 8 or Positions 37-44
....etc.

Sorry for my confusion!



"Rick Rothstein" wrote:

For a completely generic text string (like you posted), any search method
will find the "2" in "F26" before it will find the "2" in 28038.66^35. In
order to be able to differentiate between the two "2"'s, there would have to
be some kind of "positional pattern" to the characters in the text string.
Perhaps if you gave us real example text strings to look at, instead of such
a random example one, then perhaps we will be able to discern (or ask you
for clarification) an underlying pattern upon which search code can be
built.