Detecting partial contents in an array

J

JuanManuel

Hi,

I have a 2-dimensional array associated to a table. The array contains the
same data that's in the table and in the same order.

Column 9 contains data like: "CI, HGP, MI" or any combination and
permutation of these three words, but there's always at least one of them.

Is it possible to detect whether a particular cell in Column 9 of the array
CONTAINS one of these words in particular. Just to clarify, I'm not trying to
read the whole content of the cell, so reading directly from array(i,j) does
not work. I need something like:

If array(i,j) contains "HGP" then ....

In this case, even if the actual content of array(i,j) is "MI, HGP" and not
exactly "HGP", it'll go through the if.

I know there's is not such a thing as contains, but I'm asking if there's a
way to accomplish what this would do.

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top