Need help to create a formula

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

JMP Users,

        I am trying to create a row formula.

        I have a JMP data table.  I have columns labelled as: hotdog, pizza, pop, apple, banana, pear, etc.  Under each of
these columns I either have a blank or I have a number (numeric continuous) e.g., how many servings of each food I ate, for
each row.

        Now, I want to create a new column, called "foods eaten" that is a concatenated character string made up of the foods
eaten.  I do not want to pay any attention to the # of servings, just whether or not the food was eaten.  If it was eaten, it becomes
part of the concatenated string, if not eaten, it is ignored.  Hence my concatenated
strings, for each row, will look something like this:  (Note that I would like to use semi-colons to separate the concatenated items 
for greater readability

hotdog; pizza; pop; banana; pear
pizza; apple; banana
pop; apple, pear
hotdog; pear

and so on...


        Does anyone know how to create a row formula or JSL script that will create these concatenated character strings based
on whether or not a numeric item exists in particular columns?

        I would be most grateful if anyone has any ideas how to do this.

        Thank you,
        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.