Douglas j.Steele contributed Wed, Aug 11 2004 6:15 pm.
Replace$ is not available in A97. Chuck Grimsby took care
of that with his airing of the JoeReplace FN.
My Q here today is to Doug, in regard to the use of the backslash...
Is there ever an instance where
CountInstances = (Len(ToSearch) - Len(JoeReplace(ToSearch, ToFind,
vbNullString))) \ Len(ToFind)
would return a value different than
CountInstances = (Len(ToSearch) - Len(JoeReplace(ToSearch, ToFind,
vbNullString))) / Len(ToFind)
???
If not, is the wisdom behind the backslash just to produce result that
is one of the 3 Types returned by the backslash? This one-liner, BTW,
is one of my all time favorites. The simplicity of it is staggering.
Thanks again, three years later, for your excellent contribution.
|
