Selecting Only Numerals from Text Box

[shenix2005]

Hi,

I have a text box in which i will enter both numeric and text datas [Examble: "0 to 20 sets" or "0 - 20 sets" ] like this.

I will always enter two numerics and some texts like "to" or a "-" in between them. (the numeric can some times be negative also like
-1 to 20 sets)

Now i have another two text boxes where i need only the two numerals that i have entered omiting the "text" and "-".

How is it possible? pls help.

[weekend00]

if you are sure there are two and only two space with the field, you can use instr to find the position of first space, then use left to extract the first number. and use instrRev and mid function to get second number:

firstNumber: left([textfield], instr([textfield]," "))
secondNumber: mid([textfield],instrRev([textfield]," "))