Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

regular expressions question

Status
Not open for further replies.

ktucci

Programmer
Apr 23, 2001
146
US
how do i use regular expressions to look for '\w{2,5}' but not have the result be a number by itself

i would want to match:(letter number combinations)

abc1a
1abcd
abcde
1234a
a4bcd

but not:(any integer without a letter)

12345
123
12
22222

any help will be greatly appreciated

thanks

keith
 
anyone have any ideas on this one...?

thanks

keith
 
Just use the IsNumeric function:

If IsNumeric("Expression1") Then
--this is an integer only
else
--this is a letter number combination
end if
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top