Finding the First Number in a field

Is there a formula that could look up the first # in a text field?

Example

I have QFRS755-1-1 in a field.  I would need to have the formula return "7"
LVL 1
CruizectrlAsked:
Who is Participating?
 
lesouefCommented:
and after test, the 1st solution was enough though the 2nd also works (tested with v8)
0
 
lesouefCommented:
have you tried:
 left(getasnumber (field);1) ?
I have no fm to test that now...
if it does not work, try:
left ( getasnumber (field) * 1 ; 1 )
normally, the multiplication should clear off the characters and keep only the numbers from data (that was true for v6)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here