Search for integer in string

[jaye]

How do I search for an integer within a string?

 

[mdmilner]

Anytime you're looking at a string, you can use the InStr function to look within it for matches.

InStr(stringName, matchInteger)

Which returns the position of the first character that matches so...

If you're lookin at a string of:

123456789

And your search string (integer) is

456

The above function would return a value of 4

Mike

 

[khexcel]

Hi,
You can go a step further and use the instr with the mid function eg

Dim INTVALUE As Variant

INTVALUE = Mid(stringName, InStr(stringName, matchInteger), Len(matchInteger))

to return the integer itself (thinking about it, why would anyone want to get the integer itself when the integer is already known?) Anyways, the concept still remains in case you want a portion of the stringname if the integer is found.