cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
19 REPLIES 19
hogi
Level XIII

Re: Paste multiple column names

hogi
Level XIII

Re: Paste multiple column names

@BHarris  submitted wishes to restore the paste column names functionality:

Restore data-grid behavior: Pasting onto column names to rename them 

 

hogi
Level XIII

Re: Paste multiple column names

hogi
Level XIII

Re: Paste multiple column names

jcagande
Level II

Re: Paste multiple column names

Thanks!

hogi
Level XIII

Re: Paste multiple column names

 replacing column names via CTRL+V doesn't work anymore in JMP19

.... but there is a workaround:
a) select columns to rename

b) copy new column names to clipboard

c) Recode Column Names- Only selected columns 

d) "Paste Multiple"

 

JMP19 (c+d): 7 mouse clicks  -  instead of CTRL+V in JMP18

 

 

hogi
Level XIII

Re: Paste multiple column names

As an alternative, you can link a script to a Keystroke - or run it via the main menu (with 2-3 mouse clicks):

 

View more...
names default to here(1);
dt = current data table();

cols = dt << get selected columns();
oldColNames = Transform each({col}, cols, col << get name);
newColNames = Words(get clipboard(),"\!n\!t,;");
set clipboard(concat items(oldColNames, "\!t")); // poor man's CTRL + Z 

if(!(nitems(newColNames)==nitems(oldColNames)),
	Caption("# colnames doesn't match");
);

for each(  {col,idx}, cols, col << set name(newColNames[idx]));

Caption (Char(N items(newColNames))  || " column names replaced");
wait(1);
Caption(remove);
hogi
Level XIII

Re: Paste multiple column names

hogi
Level XIII

Re: Paste multiple column names

Another hidden functionality: edit table scripts by double click

JMP18:
- in the Table Scripts menu, one can double click on a script to open end edit the script
- to change the name of the script,  select it and click again

 




this is similar to Windows Explorer [sorry, difficult to distinguish Click and double click in the video - just try on your own ...]

 





JMP 19:
- click + click again: not working anymore
- double click: change the name of the script
- edit the script: only accessible via right click menu : (

I just asked JMP support [TS- ?   ] if the change was intentional ...

 



BHarris
Level VII

Re: Paste multiple column names

Wow, that's cool, I've wanted that many times.  Thanks for the tip!

Recommended Articles