InStr with RegExp

[Fixed]

Hello!

When I'm trying to find some text in another it can be found as a part of word.
For example:

HappyText = "The best [B]cat[/B]alogue."
HappyPhrase = "[B]cat[/B]"
If InStr(HappyText, HappyPhrase) > 0

or

HappyText = "[B]Log[/B]ging into the cata[B]log[/B]ue."
HappyPhrase = "[B]log[/B]"
If InStr(HappyText, HappyPhrase) > 0

I want to find the same text/word:

HappyText = "You have a [B]log[/B] of the catalogue."
HappyPhrase = "[B]log[/B]"
If InStr(HappyText, HappyPhrase) > 0

I thing I should use the RexExp to find characters and digits left and right of HappyPhrase:
Something like this:

[A-Za-z0-9] & HappyPhrase & [A-Za-z0-9]

Please help with this problem!
Thank you in advance!

 

[GTO]

@Rick Rothstein:

"...especially since I am about to go to sleep for the 'night'."

Yowza! I didn't notice how late it is there. Off to bed to watch the sunrise!

I'm still on graveyard shift (much to my chagrin), so you have my compassion/empathy. Have a good rest my friend.

Mark

 

[Rick Rothstein]

Thank you Rick, I will try this construction "If InStrExact(TextName, TypeNameO, False) > 0 Then".
I guess your UDF should be added as the separate Module?

It does not have to be in a separate module (it could be if you want to do it that way)... you can just put it in the same module your UDF is in, just put it underneath the last "End Sub" or "End Function" in that module.

 

[Fixed]

Thank you Rick, I will try this construction "If InStrExact(TextName, TypeNameO, False) > 0 Then".
I guess your UDF should be added as the separate Module?
"but your earlier examples seemed to indicate you wanted a case insensitive search to take place."
Yes.

I've tried it - it works perfectly, Rick, thanks a lot!
Good night!

 

[Rick Rothstein]

@Rick Rothstein:

"...especially since I am about to go to sleep for the 'night'."

Yowza! I didn't notice how late it is there. Off to bed to watch the sunrise!

I'm still on graveyard shift (much to my chagrin), so you have my compassion/empathy. Have a good rest my friend.

I usually go to sleep about 6am and get up at 10am (yep, I only sleep around 4 hours per night).

 

[Fixed]

I usually go to sleep about 6am and get up at 10am (yep, I only sleep around 4 hours per night).

How is it possible? When I sleep 4 hours per night during few days, I feel so bad.

 

[Fixed]

It does not have to be in a separate module (it could be if you want to do it that way)... you can just put it in the same module your UDF is in, just put it underneath the last "End Sub" or "End Function" in that module.

It works for me, thank you Rick!

 

[Rick Rothstein]

How is it possible? When I sleep 4 hours per night during few days, I feel so bad.

When I was somewhere in my late 40s, I start sleeping less (around 5 to 6 hours per night back then) and as the years progressed, I slowly started sleeping less and less. Now, I sleep around 3.5 to 4 hours per night. I don't know why, but it seems to work for me.

 

[Fixed]

Thank you for the useful information.