Only numeric value

sajjan - Aug 31, 2010 at 10:35 AM
 Ray - Aug 31, 2010 at 06:08 PM

i can read only numeric value at given bellow

Sell 45621 aa aaaaaa
Sell 4561 aa aaaaaa
Sell 456 aa aaaaaa
Sell 56 aa aaaaaa
Sell 6 aa aaaaaa

1 response

If you mean you want to extract only the numeric value within the string then this will work:

Note: This is an array so you will have to press CTRL-SHIFT-ENTER instead of just ENTER

The $20 is the len of the string from which you want to extract the number.