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

Question

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

Jeff_Perkinson · Answer

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 13

Character Functions in Formula Editor in JMP 13

michael_jmp · Answer

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