Subscribe Bookmark RSS Feed

How to use a value selected in a list ?

antoinesofradir

Community Trekker

Joined:

Apr 26, 2013

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
Solution

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

1 REPLY
Solution

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