topic Re: Copy selected data to clipboard for further processing by user in Discussions

Copy selected data to clipboard for further processing by user

VincentVandalon — Sat, 10 Jun 2023 23:42:17 GMT

My use case:

- Original data needs to be transposed and can contain information on N samples

- In most - but not all - cases the data of interest is in the first row of the transposed data

- Of the copied rows, not all columns should be copied, only the ones namens "Row 3, Row 4, Row 5" (the columns are named row because of the transpose).

- This data needs to be copied to the clipboard for further processing. This can by pasting into another JMP table or somewhere else.

The first steps are very trivial, however, copying the data to the clipboard seems not to work. I have tried (many) variants of the following:

Names Default To Here( 1 );
dt = Current Data Table();
Tdt = dt << Transpose( columns( :"1st Thickness"n ), By( :FOUP SLOT ), Output Table() );

Tdt << Select Rows( [1] ) << Select Columns(
	 :Row 3, :Row 4, :Row 5
)<<Copy Selected Table Row();

Re: Copy selected data to clipboard for further processing by user

jthi — Sun, 09 Jan 2022 11:34:18 GMT

Copy Selected Table Rows() doesn't seem to work with Datatables but with Table Boxes and datatable boxes

You could use the Copy With Full Precision found from Edit menu:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
col_list = {"age", "name", "height"};
dt << Select Rows([1]) << Select Columns(col_list);
Main Menu("Copy With Full Precision", dt << get name);

Re: Copy selected data to clipboard for further processing by user

VincentVandalon — Sun, 09 Jan 2022 12:15:15 GMT

Thanks, I had no idea one could select entries from the menu like that... works like a charm!