Subscribe Bookmark RSS Feed

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


Community Trekker


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





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}]," = ")


Hope that helps,


Michael Crotty
Sr Statistical Writer
JMP Development

Community Manager


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