cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
10 REPLIES 10
hogi
Level XII

Re: Paste multiple column names

If you know about and use the function, please comment or vote here.

 

The function is so hidden and undocumented that it may be deleted in a future version of JMP.

WebDesignesCrow
Super User

Re: Paste multiple column names

Wow. Thank you for sharing

BHarris
Level VI

Re: Paste multiple column names

Now that I know about this, I use it all the time -- copy the column headers out to a text document, change them, then paste them back in.  So handy!  I *really* hope this feature stays in JMP 19!

hogi
Level XII

Re: Paste multiple column names

Did you know?
copy/paste via CTRL+C / CTRL-V also works for Value Labels 

 

BHarris
Level VI

Re: Paste multiple column names

What are you copying from in this case?  Tab-delimited text file perhaps?

hogi
Level XII

Re: Paste multiple column names

 Tab-delimited text works.

A 2
B 3


easiest: get it from a JMP or Excel data table - via CTRL-C.

Then select the empty list box and Press CTRL+V

mikedriscoll
Level VI

Re: Paste multiple column names

I kind of doubt they would get rid of this function, as it is part of the usefulness of the column pane. Another way I use this is to first select whatever rows I need (either to copy / paste, or maybe tables->subset a subset of rows and columns), and then use the column filter at the top of column pane to filter on and select my subset of columns. Now that my rows and columns are selected, I then hit 'tab' twice to bring focus over to the data pane.  Then I can hit ctrl+C (copy data) or ctrl+shift+C (copy data with column names) and then paste them wherever they are going.  Or tables->subset if using that feature.

 

People may not be aware so I'll post the corresponding paste functions:

If pasting to Excel, simple ctrl+V (or regular paste) will work regardless of whether you have previously copied only data or data + columns.

If pasting to a JMP table, ctrl+V will paste the data. ctrl+shift+V will paste the data+column names. Choose based on how you copied the data. It's straightforward if you are pasting into a new / empty table. If you are pasting into a table and have already selected columns and rows in the destination table of where you want the pasted data to go... well, just make sure your row / column selections are 100% correct, and check it after.

hogi
Level XII

Re: Paste multiple column names

using Tab
nice! - more robust than "clicking somewhere in the data grid"

- and sounds safe against changes in new versions.

-> added to CTRL/Alt/Shift + click/select/double click/right click 

mikedriscoll
Level VI

Re: Paste multiple column names

Agreed, and more importantly for the use described above, you don't lose the column and row selections when you tab from pane to pane. If you click in the data grid (after working in the column pane) on to a cell or column header you've lost your previous selection.

Recommended Articles