topic Re: Select a group of cells in a column in Discussions

Select a group of cells in a column

SamH — Wed, 24 May 2017 22:16:58 GMT

Hi, I have table with thousands of rows. I need to be able to select a group of cells in one column, so I could copy it into another table. for example for Column: "Test3 (VOLTS)" only I need to copy cells highlighted in yellow from row 4 thru row 18 using JSL code.

Thanks

Re: Select a group of cells in a column

txnelson — Wed, 24 May 2017 23:31:32 GMT

Here is a simple example of one way to do it

Names Default To Here( 1 );

dt = Open( "$sample_data\big class.jmp" );

// copy the names from row 2-6
NameCpy = dt:name[Index( 2, 6 )];

dt2 = New Table( "copied", New Column( "new name", character ) );
dt2 << add rows( 5 );

// copy to new table
For( i = 1, i <= 5, i++,
	dt2:new name[i] = NameCpy[i]
);

If you actually have physical rows that are selected, you can easily get their row number with a:

dt<<get selected rows

Re: Select a group of cells in a column

SamH — Wed, 31 May 2017 21:23:57 GMT

Thanks that should work, I tried with Big class file.

Much appreciated

Sam.

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 21:24:56 GMT

Hi Jim, how can I select a range of cells withing one column?

for example if I want to select cell 2 thourgh cell 19 within the same column.

Because I want to use this selection to be able to do "Select Matching Cells" within the same column.

Thanks

Sam

Re: Select a group of cells in a column

txnelson — Mon, 26 Jun 2017 21:34:06 GMT

Here is the example for "Select Matching Cells" taken from

Help==>Scripting Index

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Rows( [1, 2, 3, 4] );
dt << Go To( :Height );
Wait( 2 );
dt << Select Matching Cells();

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 21:38:51 GMT

Hi Jim, instead of hand picking what cells to select, can I pick a range let's say 2-19?

Thanks

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 21:45:35 GMT

or row 12 thru 40 in column "height"

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 21:47:21 GMT

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 21:50:47 GMT

Jim, I am trying to automate this process, because the files I am dealing with could have 1k-2k rows. if I have to specify every row, my code will be so many pages.

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 21:56:37 GMT

Jim, I figured it out, here is the code it works.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
L = N Rows( dt ); // number of rows
For( i = 3, i <= L, i++,
dt << Select Rows( i, L );
dt << Go To( :Height );
);
Wait( 2 );
dt << Select Matching Cells();

Re: Select a group of cells in a column

txnelson — Mon, 26 Jun 2017 22:08:16 GMT

The point I was making in showing you the last piece of code, was that you can specify a matrix [........] of values (rows) that you can use to select the rows you want. There are a multitude of ways to populate a matrix. The capabilites of populating matricies are listed in

Help==Books==>Scripting Guide

Given your current code, I would probably use an Index() function. It would make the code far more efficient. Also, using Wait(0); will force the processing to finish the selection before moving on, rather than having to guess on how much time you need to wait.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
L = N Rows( dt ); // number of rows
//For( i = 3, i <= L, i++,
dt << Select Rows( Index( 3, L ) );
dt << Go To( :Height );
//);
Wait( 0 );
dt << Select Matching Cells();

Re: Select a group of cells in a column

SamH — Mon, 26 Jun 2017 22:21:53 GMT

Thanks Jim.

Sam