nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

data cleaning- special character

joann

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

Accepted answers

txnelson

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

example.jmp

All comments

txnelson

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

example.jmp

joann

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

txnelson

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

joann

It works! Thanks a lot Jim!!

Mark_Bailey

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.

Georg

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 )