Find/Extract number from a string

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Does anyone know how I would programatically extract the second instance of a
number in this given string?

Robot dispenses bead 6.00 diameter (mm), 1000.00 distance (mm)

The second number would be 1000.00 and will vary. This will not always be
the value, but it will always be the second number in the string.

Thank you.

Sarah
 
Try this --
Expr1: Val(Mid([Urtext],InStr([Urtext],"),")+3,InStrRev([urtext],"distance")))
 
Thanks! That worked great.

KARL DEWEY said:
Try this --
Expr1: Val(Mid([Urtext],InStr([Urtext],"),")+3,InStrRev([urtext],"distance")))
--
KARL DEWEY
Build a little - Test a little


Sarah said:
Yes the only thing that changes are the 2 numbers (6.00 and 1000.00).
Click to expand...
Click to expand...
 
Back
Top