<div>
have you tried:<br />
&nbsp;left(getasnumber (field);1) ?<br />
I have no fm to test that now...<br />
if it does not work, try:<br />
left ( getasnumber (field) * 1 ; 1 )<br />
normally, the multiplication should clear off the characters and keep only the numbers from data (that was true for v6)
</div>


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)

<div>
<div class="content wysiwyg-content">
Is there a formula that could look up the first # in a text field?<br />
<br />
Example<br />
<br />
I have QFRS755-1-1 in a field. &nbsp;I would need to have the formula return &quot;7&quot;
</div>
</div>


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"

Finding the First Number in a field

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.