Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

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"
0
Cruizectrl
Asked:
Cruizectrl
  • 2
1 Solution
 
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
 
lesouefCommented:
and after test, the 1st solution was enough though the 2nd also works (tested with v8)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now