Subscribe Bookmark RSS Feed

How to change the order of words with character functions in JMP13?

jenssjorslev

Community Trekker

Joined:

Feb 5, 2015

Have entries from an Excel validation list as  

xyz = 1

ABC = 2

Want to use them as Value labels in JMP, but need to change the order to

1 = xyz

2 = ABC

Anybody who can help how to do that?

And BTW:

anybody knows how to extract Validation lists from Excel for Mac?

and lastly

what happended to the character function 'Shift' in JMP 13? - it was there in JMP 12

cheers

2 REPLIES
michael_jmp

Staff

Joined:

Jun 23, 2011

I can't answer your question about Excel for Mac, but I do see the Shift() function in the Scripting Index in JMP13, at least on Windows.

 

For your first question, would something along these lines work:

excel_list = {"xyz = 1", "ABC = 2"};
jmp_list = {};

For( i=1, i<=nitems(excel_list), i++,
	jmp_list[i] = concat items(words(excel_list[i]," = ")[{2,1}]," = ")
);

show(jmp_list);

Hope that helps,

Michael

Michael Crotty
Sr Statistical Writer
JMP Development
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

I'm not sure I understand your question. Could you give us an example of what you have in JMP and what you would like? 

 

As for the Shift() function, it's still in JMP 13 (see the screen shot of the Scripting Index) but it did get removed from the Characters section of the Formula Editor. I'll make a note internally and see if we can get back in that list.

 

Scripting Index from JMP 13Scripting Index from JMP 13

Character Functions in Formula Editor in JMP 13Character Functions in Formula Editor in JMP 13

-Jeff