Removing numbers from a text field.

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?

jarrodpriceAsked:
Who is Participating?
 
lesouefConnect With a Mentor Commented:
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
 
jvaldesCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.