How I can separate number and character in cell in JMP

[#1]

Hi ,

I have question about JMP , I have column with numbers (0) and letters so I need to create new column and using formula include only the letters and delete all (0) ! so is it possible to do that in JMP ? and which function I should use ?

I tried (word) function but it does not work with me!

Here the column :

and I want something like this :

Thanks

[#2 · Accepted solution]

If you just want to replace 0 with empty strings, you can use Substitute

Names Default To Here(1);

str = "00000000J";
Substitute(str, "0", "");

[#3]

Thanks!