how to remove $ from $123.

[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.....