topic Re: Scripting > List > Remove Missing Values in Discussions

Scripting > List > Remove Missing Values

Thierry_S — Fri, 09 Jun 2023 22:09:12 GMT

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,

Re: Scripting > List > Remove Missing Values

Ryan_Gilmore — Mon, 22 Mar 2021 15:45:31 GMT

Hi @Thierry_S ,

Try this,

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

Re: Scripting > List > Remove Missing Values

ian_jmp — Mon, 22 Mar 2021 16:03:40 GMT

Alternatively:

NamesDefaultToHere(1);

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

Re: Scripting > List > Remove Missing Values

Thierry_S — Mon, 22 Mar 2021 16:56:18 GMT

Hi Ian,
Nice touch with adding "42" to the list: let's stay clear of the Vogon ;)
Best,
TS

Re: Scripting > List > Remove Missing Values

Mark_Bailey — Mon, 22 Mar 2021 16:56:42 GMT

Also,

Names Default to Here( 1 );

original = [.,.,.,2,3,4,7,.,.,.];

none missing = original[Loc( Not( Is Missing( original ) ) )];

Re: Scripting > List > Remove Missing Values

Valerio — Wed, 06 Jul 2022 16:49:58 GMT

Hi Ryan,

I don't know why but your script does not work for me... (I have JMP 16, in case it can help to debug the issue)

Re: Scripting > List > Remove Missing Values

pmroz — Wed, 06 Jul 2022 17:09:24 GMT

Can you supply a code snippet and the error message?

If your list contains character strings then loc will not work - it's only for numbers.

Here's a solution for a list of strings with empty values.

a = {"a", "", "b", "", "c", "d", "e"};
b = concat items(a, ";");
c = words(b, ";");

Challenge: anyone with an alternate solution?

Re: Scripting > List > Remove Missing Values

vince_faller — Wed, 06 Jul 2022 23:36:18 GMT

In case you already haven't figured it out. it does work but it only returns a copy. if you want to alter x you'd have to either reassign it or use removefrom()

Names default to here(1);
x = {.,.,.,2,3,4,7,.,.,.};
new_x = remove(x, as list(loc(x, .)));
show(x, new_x);
removefrom(x, as list(loc(x, .)));
show(x, new_x);