370333_en-US

liliconcom

Scripting > List > Remove Missing Values

Hi JMP Team,

I'm looking for a method to remove missing / empty values from a List generated within a script:

The initial List looks like: {.,.,.,2,3,4,7,.,.,.} and I would like to end up with a new List = {2,3,4,7}.

Any ideas how to achieve that without relying on a a loop through the List elements?

Thanks.

Best,

TS 

ScriptingRe: Scripting > List > Remove Missing Values

Hi @Thierry_S ,

 

Try this,

 

x = {.,.,.,2,3,4,7,.,.,.};
remove(x, as list(loc(x, .)));

Re: Scripting > List > Remove Missing Values

Alternatively:

NamesDefaultToHere(1);

in = {.,.,.,2,3,4,7,.,42,.};
out = in[LocNonMissing(in)];
Print(out);

Re: Scripting > List > Remove Missing ValuesHi Ian,
Nice touch with adding "42" to the list: let's stay clear of the Vogon;)
Best,
TS