How to use a value selected in a list ?

antoinesofradir — Thu, 13 Jun 2013 13:30:45 GMT

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 !

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

ms — Thu, 13 Jun 2013 13:49:57 GMT

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) ));

topic How to use a value selected in a list ? in Discussions

How to use a value selected in a list ?

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