How to retrieve only numbers(decimal or non decimal) from a alpha numericstring

There are a number of ways to do this, but I'd probably go with a regex:

\d+\.?\d*|\d*\.?\d+

will find:

1
86
23.4

etc. or if you want the number just are the start then use this:

^(\d+\.?\d*|\d*\.?\d+)

Which will extract the 1.23 part from your example, but return nothing for

Here 1.23 is the number

Hello,
Actually i don't have a Vbscript for your requirement but i have javascript.
Please check it and convert it in VBscript if you can.
but this script surely give you desired output.

var txt = "GUJ 12.50 VAT";
var numb = txt.match(/\d+./g);
numb = numb.join("");
alert(numb);

//You’ll get 12.50 in numb….



Please let me know it is useful for you or not?