hidden secret in JMP: you can paste multiple column names via CTRL+C | CTRL+V
https://community.jmp.com/t5/Abstracts/Plenary-John-Sall-on-Secret-Features-of-JMP/ev-p/849554 @ 44min:
https://community.jmp.com/t5/Abstracts/Advanced-Data-Preparation-10-Essential-Tools-in-JMP-to-Get-From/ev-p/849401 ( @jules )
https://community.jmp.com/t5/Discussions/Possible-to-rename-all-columns-in-a-table-from-a-list/m-p/500922/highlight/true#M73532 ( @txnelson )
edit: removed in JMP19please vote:
Restore data-grid behavior: Pasting onto column names to rename them duplicates:Please restore ability to copy-paste column names from one table to another
Restore Column Name Update Via Paste
[More Topic Containers like this]
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.
Wow, that's cool, I've wanted that many times. Thanks for the tip!
Wow. Thank you for sharing
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!
Did you know?copy/paste via CTRL+C / CTRL-V also works for Value Labels
edit:in JMP 19, pasting value labels doesn't work via CTRL+V, but via paste from the right click context menu:
What are you copying from in this case? Tab-delimited text file perhaps?
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.
using Tabnice! - 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
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.
