Solved

Removing numbers from a text field.

Posted on 2007-04-09
2
237 Views
Last Modified: 2010-04-27
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?

0
Comment
Question by:jarrodprice
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Expert Comment

by:jvaldes
ID: 18880694
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....
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 18880730
If think jvaldes just shows the opposite, you wanna keep the characters, not the numbers.
so you can use his function, but put the entire alphabet as the filter parameter instead.
if the characters string length is constant, you can use left(serial;5) if there are 5 characters in the serial string.
also note:
that the quickest way to filter numbers is *1: abc132 * 1 = 132
and that it would have been easier to have the serial number separate (w/o characters) then adding characters to it, rather than stripping numbers afterwards.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

732 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