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?

score 8 · Accepted Answer · answered Nov 10 '10 at 02:30

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 '10 at 02:30

Gareth Davidson

4,857
2
26
45

Worked great, btw. Thank you! – donut Dec 21 '10 at 02:26

score 2 · Answer 2 · answered Nov 10 '10 at 04:48

2

The IsNumeric function?

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

answered Nov 10 '10 at 04:48

Tmdean

9,108
43
51

score 1 · Answer 3 · answered Aug 20 '13 at 14:10

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 '13 at 14:10

answerman

11
1

Check a string for non-numeric characters in VBScript

3 Answers3