cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
antoinesofradir
Level III

How to use a value selected in a list ?

Hi, i selected a value in a list thanks to a window, this value is keep in a variable.

i would like now to select the lines in my data table which correspond to this value, how can i do ?

here my script :

value = {"1","2","3","4"};

New Window( "window",
Outline Box( "example",
  H List Box( Text Box( "select value" ), listvalues= list Box(value, nlines(4))),
  Button Box( "OK",
    value = (listvalues << Get selected);
    nw << Close Window;)
)
);


dt << Select Where(variable== value);

thanks for your help !

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to use a value selected in a list ?

Value will be a List of strings. Char must be used if variable is numeric.

If only one item is to be selected selected, this should work:

dt << Select Where(contains(char(variable)==value[1] ));

The below works also if several items are selected:

dt << Select Where(contains(value, char(variable) ));

View solution in original post

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to use a value selected in a list ?

Value will be a List of strings. Char must be used if variable is numeric.

If only one item is to be selected selected, this should work:

dt << Select Where(contains(char(variable)==value[1] ));

The below works also if several items are selected:

dt << Select Where(contains(value, char(variable) ));