Instr Function 2

[Bluejay07]

Hello,

I am using VB6 and have a question regarding the Instr() function.

If I have a string similar to:
1, 11, 2, 12, 3, 17, 4, 20, 5, 18, 19

Say this string is stored in m_strNums

I want to find if a particular value can be found in the string, except I am facing the limitations of this function.

If I were to use:
InStr(1, m_strNums, 8)
The function returns 33 as 8 is found in the 33rd position; however, the 8 found is part of 18.

How can I search the string for a single value? (I hope this is clear).

 

[HughLerwill]

You need to be looking for ", 8," not just "8".

 

[gmmastros]

Adding to HughLerwill's suggestion....

InStr(1, ", " & m_strNums & ",", ", 8,")

This should accommodate searching for the first or last item.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Bluejay07]

Thank you both for your help.

Things seem to work with your suggestions.