nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

33261_en-US

liliconcom

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

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

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

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

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

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);