how to remove $ from $123.

[sudhirzpatil]

Hi
I have variable which has $123 as a value.
I want to remove $ from it so that i can perform mathematical operation on that variable.
Can any one tell me how to remove $ ?

Thanks in Advance

[elsekra]

Hi
You can use text function :

Code:

a=Cstr($123)
b=mid(a,2,len(a))  'b take value "123"

use after conversion function to converte your variable to integer or other

[sreekanth chilam]

Hi Sudhir,

it can be done in many ways as given below.

Way 1:

Code:

x="$123"
   x_val=Right(x,(len(x)-1))        ' use the "Right" built-in function & retrieve required value
  The above x_val contains only  "123".

Way 2:

Code:

x="$123"
  x_val=""
   For i=1 to len(x)
        y=mid(x,i,1)
           If (isnumeric(y)=True )Then
                   x_val=x_val&y
          End If
   Next

   msgbox x_val

Here above 'x_val' variable contains only "123"


Simillarly.. we can go for may ways .....
Just try from ur end & see.....

[sudhirzpatil]

Hi elsekra and Srikhant

Thanks a lot. Both sol works for my script.