<div>
Jarrod,<br />
<br />
<br />
Create a Calculation field named NumbersOnly and set the calculation to:<br />
<br />
Filter ( Serial ; &quot;0123456789&quot;)<br />
<br />
Where Serial is the name of the Text field where you have your mixed text and numbers<br />
<br />
the results will be only numbers between 0 and 9 that exist in the mixed field<br />
<br />
Let me know if this is what you wanted.... 
</div>


Jarrod,


Create a Calculation field named NumbersOnly and set the calculation to:

Filter ( Serial ; "0123456789")

Where Serial is the name of the Text field where you have your mixed text and numbers

the results will be only numbers between 0 and 9 that exist in the mixed field

Let me know if this is what you wanted....

<div>
<div class="content wysiwyg-content">
I have a field that combines a serial number with text. &nbsp;I want to create another field that shows only the text without the numbers.<br />
<br />
Is there a way to calculate the second field to show the first field, but without any numbers?<br />
<br />

</div>
</div>


I have a field that combines a serial number with text.  I want to create another field that shows only the text without the numbers.

Is there a way to calculate the second field to show the first field, but without any numbers?



Removing numbers from a text 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.