How to indicate if string has numeric value

Question

I loop over string variable data which may have integer numeric value, like "123". If this string variable has numeric value, I want to indicate it and thought to use some like this:

If IsNumeric(CInt(data)) Then 
    WScript.Echo "Number"
Else
    WScript.Echo "String"
End If

But CInt() raises error every time data variable can't be converted to integer:

Type mismatch: 'CInt'

How can I indicate if string has integer value in vbscript?

Just found out that CInt() is not necessary for IsNumeric() to function as expected. Removing CInt() function is solution. — theta
– theta, Commented Jul 12, 2012 at 11:08

Amol Chavan · Accepted Answer · 2012-07-12 11:21:38Z

11

IsNumeric Function of vb script can be used to determine whether an expression can be evaluated as a number.It returns Boolean value depending upon expression

Please be noted that IsNumeric returns False if expression is a date expression.

Now, in your code you have mistaken that even if it is not number, you trying to convert it into integer

You can use this in your code like this--

If IsNumeric(data) Then       
   WScript.Echo "Number"
Else
   WScript.Echo "String"
End If

answered Jul 12, 2012 at 11:21

Amol Chavan

4,0201 gold badge23 silver badges33 bronze badges

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

1 Comment

Milan Over a year ago

I am sure this is a common knowledge but if the string you pass into the IsNumeric() looks like this "1013230924d3" or this "1013230924E3" it will still evaluate to TRUE. D and E are considered scientific notations and things tend to slip through the crack :)

user1519979 · Accepted Answer · 2012-07-12 11:13:18Z

1

only for integers:

If VarType(data) = vbInteger Then
    WScript.Echo "Integer"
Else
    WScript.Echo "Something else"
End If

for numbers:

If IsNumeric(data)
    WScript.Echo "Number"
Else
    WScript.Echo "string"
End If

answered Jul 12, 2012 at 11:13

user1519979

1,87415 silver badges28 bronze badges

1 Comment

user66001 Over a year ago

For VBScript, which the OP's question is tagged with at least now, one needs to swap vbInteger for the number in (for example) this page which corresponds to the variable they are looking to check type of.

Collectives™ on Stack Overflow

How to indicate if string has numeric value

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related