how to remove $ from $123. - Printable Version

how to remove $ from $123. - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: how to remove $ from $123. (/Thread-how-to-remove-from-123)

how to remove $ from $123. - sudhirzpatil - 02-02-2009

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

RE: how to remove $ from $123. - elsekra - 02-02-2009

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

RE: how to remove $ from $123. - sreekanth chilam - 02-02-2009

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

RE: how to remove $ from $123. - sudhirzpatil - 02-03-2009

Hi elsekra and Srikhant

Thanks a lot. Both sol works for my script.