Solved

Removing numbers from a text field.

Posted on 2007-04-09
2
240 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

690 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