split a variable

[Brian]

Hey guys,

I have a variable that is getting passed to me in the form of -
VarA = $2000.
My problem is when i start to try and use this variable as an Integer....such as when i try and add my variable to another integer -
VarA + 300 = VarB

Here i get a "type mismatch" error. (due to the $ sign in front of the 2000)

My question would be does anybody know how i can strip the $ sign away so that im left with just the Integer?

Thanks,
Brian

[stech]

convert that to an int using cint. for ex.
MyDouble = "$2000"
MyInt = CInt(MyDouble)
Msgbox (MyInt) will do the trick.

[niranjan]

Try using Split function.
Example:

Code:

Dim StrMsg, MyArray
StrMsg = "$2000"
MyArray = Split(StrMsg, "$", -1, 1)
' now
' MyArray(0) contains ""
' MyArray(1) will contain 2000

Msgbox MyArray(1)

[mag]

You can also use this,
d = "$1000"
msgbox Right(d, (Len(d)-1))