Solved

Removing numbers from a text field.

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

808 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