Check a string for non-numeric characters in VBScript

Question

I'm working on a Windows application that's written in VBScript and I need to check a string for any non-numeric characters, specifically anything a-z. I realize I could probably do this using the InStr() function in conjunction with a loop that checks for a-z but that just seems ridiculous. I have very little experience in VBScript so I really don't know where to go on this.

What's a good method for handling this kind of situation?

Gareth Davidson · Accepted Answer · 2010-11-10 02:30:45Z

8

Use a regular expression:

Set re = New RegExp
re.Pattern = "[a-z]"
re.IgnoreCase = True
re.Global = True
hasMatches = re.Test("12345abc")

If hasMatches = True Then
    ' it has letters
End If

answered Nov 10, 2010 at 2:30

Gareth Davidson

4,9572 gold badges28 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

donut Over a year ago

Worked great, btw. Thank you!

Tmdean · Accepted Answer · 2010-11-10 04:48:24Z

2

The IsNumeric function?

If IsNumeric(x) Then y = CDbl(x)

answered Nov 10, 2010 at 4:48

Tmdean

9,32946 silver badges51 bronze badges

Comments

answerman · Accepted Answer · 2013-08-20 14:10:54Z

1

a little late but an answer.

if you work with isnumeric and you set a Not in front to check if there is NO NUMBER. But every sign like !"§$%& and so on will be ignored and will be put into the check

answered Aug 20, 2013 at 14:10

answerman

111 bronze badge

Collectives™ on Stack Overflow

Check a string for non-numeric characters in VBScript

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related