data cleaning- special character

[#1]

Hi, I have a messy column "zip code" filled with all kinds of special characters. Is there a way I can quickly remove all the special character and leave the string using JMP's function but not jsl? Thank you. 

AZ23105

,06385

[29466]

@11768

*****10065

[#2 · Accepted solution]

I am not aware of a JMP builtin function that will convert the data as needed.  However attached is a data table where I have created a new formula column that will remove all non numeric values

[#3]

Thank you Jim! Is there a way to keep the 0 in front of the string? like "06385" but not "6385".

[#4]

If you make the column a character column, and then change the last line in the formula from
Num( Number );
to just
Number;

[#5]

It works! Thanks a lot Jim!!

[#6]

Just another approach using regex, but not so easy to understand:

It replaces all occurrences in :column1 that are not digits by "".

Regex( :Column 1, "[^0-9]", "", GLOBALREPLACE )

[#7]

You should also look at the Rows > Recode command. It has been significantly enhanced over several recent versions of JMP. Many problems with data (e.g., inconsistency) can be directly handled with the Recode tool now without resorting to formulas or scripts.