String Contains 1

[simoncpage]

What the quickest way of looking in a string to see if it contains a certain word (like the strings "hello1234" or "hello 1234" and seeing whether hello is contained in it)

Thanks
Simon

 

[dsi]

Try the Instr() method.

 

[JohnYingling]

Dim lngInstr As Long
lngInstr = Instr(1,strW,"hello",1) ' 1 = Case Insensitive

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[simoncpage]

All very good but I want a non-case sensitive version???

Anyone?

 

[acron]

Actually I think you will find that JohnYingling's suggestion is non-case sensitive.

If the final argument is 0 (zero), then a binary camparison is performed, hence Case Sensitive. 1 (as used above) causes a Textual comparison, which is noncase-sensitive.

A.C.

 

[simoncpage]

YOur right thanks alot..Im just being dumb today!