|
JMP Users, Sorry, my original message (below) apparently was not clear enough. Thanks for the quick responses from Mark Bailey and Donald Palahnuk, but I do not understand how to utilize the suggested answers (if possible) as a simple row formula. I am looking for a JMP formula, typically created using the formula editor. I am not looking for a JSL script (although mabe this will work?) Formulas (when copied from the JMP Formula Editor GUI using SNAGIT and pasted into Lotus Notes looks something like this: 
If I directly copy and paste into Lotus Notes the formula looks like this: If( :Name("Prob(Classification Set 03==1) Model 10") > 0.4, 1, :Name("Prob(Classification Set 03==2) Model 10") > 0.4, 2, :Name("Prob(Classification Set 03==3) Model 10") > 0.4, 3, Empty()) Again, I would be most grateful if someone could help me. Thank you, Regards, Jim Metz ************************************* original message below here ************************************************************** JMP Users, Can someone please help. I am trying to create a JMP formula which will count the occurence(s) of a character or small group of characters in a string. For example, I would like to count the number of "{" left squiggle braces in a character string. Another example, I would like to be able to count the number of occurences of "C1ccC1" in a character string. I would be most grateful if someone could figure out a row formula how to do this. Thank you. Regards, Jim Metz James T. Metz, Ph.D. Research Investigator Chemist GPRD R46Y AP10-2 Abbott Laboratories 100 Abbott Park Road Abbott Park, IL 60064-6100 U.S.A. Office (847) 936 - 0441 FAX (847) 935 - 0548 james.metz@abbott.com This communication may contain information that is legally privileged, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, use, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or return email and delete it from his or her computer. |