search for multiple words in a string

**pcbpinoy** · 10-28-2011, 02:51 AM

I was trying to search at least two words in a string then execute a code. For example, I have

string = "CD_HJ_TY_AB"

Here's what I like to accomplish:
1. Find AB and CD
2. If found, do something. Else do nothing.

I tried to use Instring() and AND but I can't get it working.
Any suggestions?

**nilem** · 10-28-2011, 03:05 AM

For example:

Please Login or Register  to view this content.

**pcbpinoy** · 10-28-2011, 03:11 AM

thanks a lot.. i was doing

s = "CD_HJ_TY_AB"
If (InStr(s, "AB") =1) And (InStr(s, "CD")=1)

**nilem** · 10-28-2011, 04:03 AM

pcbpinoy, then, perhaps, would be correct this:

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

search for multiple words in a string

LinkBack

Thread Tools

Rate This Thread

Display

search for multiple words in a string

Re: search for multiple words in a string

Re: search for multiple words in a string

Re: search for multiple words in a string

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions