topic Re: How do I get Comma separated user input to subset rows with specific value? in Discussions

How do I get Comma separated user input to subset rows with specific value?

psundar6 — Fri, 09 Jun 2023 00:29:57 GMT

Hi, I have a data table that contains information in the below format. I'd like to create a button on jmp that when clicked should prompt to enter a list of comma separated values from the user (possibly in a text box?) to subset just the rows with that value in a specific column.

For example in the text box if the user chooses BB,EE, then in the attached table (sample_table.jmp) only those rows will be subsetted out to form a new table.

How do I accomplish this using JSL? Thanks!

Re: How do I get Comma separated user input to subset rows with specific value?

txnelson — Fri, 05 Mar 2021 22:30:01 GMT

Here is one of the many ways this can be done

names default to here( 1 );
dt = Current Data Table();
dt << clear select;

NW = New Window( "Select",
	V List Box(
		Text Box( "Input a comma separated list th the Names you want subsetted" ),
		teb = Text Edit Box( "", <<set width( 150 ) ),
		Button Box( "OK",
			i = 1;
			val = teb << get text;
			While( Word( i, val, "," ) != "",
				theWord = Word( i, val, "," );
				dt << select where( :name == theWord, current selection( "extend" ) );
				i++;
			);
			dtSub = dt << subset( selected rows( 1 ), selected columns( 0 ) );
		)
	)
);

Re: How do I get Comma separated user input to subset rows with specific value?

psundar6 — Sat, 06 Mar 2021 01:14:49 GMT

Thanks Jim! That does it.