Hi,   I'd like to get some help on finding a specific string (actually 2 strings, say "JMP1" and "JMP2") that may be within a column with text, as we move down that column, and then have a formula column next to it to label "JMP1" or "JMP2", if it finds it, or label say "NA" otherwise.    A couple of notes: 1- "JMP1" or "JMP2" can be in any position within the text in Column 1 2- "JMP1" and "JMP2" are not contained in the same text in Column 1   So in my mind it will be something like this for the Formula Column (Column 2 - the label column):   IF (Column 1 contains "JMP1", then Column 2 = "JMP1", else (IF Column 1 contains "JMP2", then Column 2 = "JMP2", else Column 2 = "NA"));   I looked up to the Match function, but I got a bit confused with the multiple arguments and expressions. Maybe I'm not on the right track either, hence why I need advice   It will be great if someone could share their thoughts (preferably through the Formulas area, but will be open to suggestions through JSL).   Thanks, Vasco ... View more

Hi everyone,   I have a question about the consistency of how JMP displays the Capability and Performance Indices.   I'm going through the STIPS course @mia_stephens  at the moment and, in the Quality Methods Module 3 - Process Capability, it was really clear to me that the software may have inconsistencies in the message with regards to this subject. I have used the Impurity.jmp example to illustrate this.     1. If we run a capability analysis through the Distribution plattform for the variable Temp, and leave the Long Term Sigma selected, we will get a Long Term Capability Indices in the for of Cp, Cpl, Cpu, Cpk, which I think it's not quite right.     2. If, however, we use the same data and run the capability study through the Control Chart Builder, we get a clear distinction between Within and Overall Sigma, using the correct indices terminology, i.e., Capability and Performance indices, respectively.      Please note that the indices in point 1 above, in the form of Capability, are the same as the Performance indices in point 2.   Looking forward to read your comments on this as, at least for me, this generates confusion in the terminology used against its definitions.   Thanks, Vasco Cachaco ... View more