how to get only numeric values from text

[PrabhatN]

Hi Sandeep,

Try the following code snippet:

Store the value (Rs.4500.00/- or anything) in a variable, say myVar

myVar = Split(myVar,"Rs.")
myVar1 = myVar(1) \\ it will give you 4500.00/-
myVar1 = Split(myVar1,"/-")
myVar2 = myVar1(0) \\ it will give you only 4500.00

In this way you are removing Rs. and /- from any value and it will work for all values provided the format doesn't change