Solved

Finding the First Number in a field

Posted on 2006-06-08
2
245 Views
Last Modified: 2010-04-27
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
Comment
Question by:Cruizectrl
  • 2
2 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 16868035
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
 
LVL 28

Accepted Solution

by:
lesouef earned 50 total points
ID: 16894017
and after test, the 1st solution was enough though the 2nd also works (tested with v8)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now