442530_en-US

liliconcom

How I can separate number and character in cell in JMP

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

AnalyticsWindowsRe: How I can separate number and character in cell in JMP

Thanks!

Re: How I can separate number and character in cell in JMP

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

 

Names Default To Here(1);

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