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

How I can separate number and character in cell in JMP

Balqees — Fri, 09 Jun 2023 00:42:48 GMT

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

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

jthi — Sun, 05 Dec 2021 14:50:07 GMT

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

Names Default To Here(1);

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

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

Balqees — Sun, 05 Dec 2021 16:28:36 GMT

Thanks!