Re: Need help to create a formula

["James T Metz" <james.metz@abbott.com>]

Mike,

        Your formula (below) works beautifully!

        Thank you for your help.

        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.

Michael Young <meyoung@siu.edu> Sent by: jmp-l-owner@lists.biostat.wustl.edu 06/02/2005 08:27 PM Please respond to jmp-l

To:        jmp-l@lists.biostat.wustl.edu         cc:                 Subject:        Re: [jmp-l] Need help to create a formula

Dr. Metz,
Here's a column formula that worked for a simplified version of your situation (just three food columns):

t3 = If( :hot dog > 0, "hot dog;", "") || If( :pizza > 0, "pizza;", "") || If( :pop > 0, "pop;", ""); Substr(t3, 1, Length(t3) - 1)

You just concatenate the results of a series of If statements.  The result is assigned to a temporary variable (t3 in my example) only because the concatenation method will leave you with an extra semicolon at the end; the substr removes that extra semicolon. 

If I understood your problem correctly, this should do the job.

Cheers,
Mike
-- 

Dr. Michael E. Young            http://www.siu.edu/~psycho/bcs/young.html
Southern Illinois University   618/453-3567
271F Life Sciences II                       
Carbondale, IL 62901-6502