Re: Zero filling a subset of a JMP table

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

Gunter,

        Thanks. Your suggestion works just fine.

        I did not realize that one could do a search and
replace on the " . " in cells (numerical data).

        Thanks again.

        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.

<Gunter.Hartel@csl.com.au> Sent by: jmp-l-owner@lists.biostat.wustl.edu 07/11/2005 05:20 PM Please respond to jmp-l

To:        <jmp-l@lists.biostat.wustl.edu>         cc:                 Subject:        Re: [jmp-l] Zero filling a subset of a JMP table

Jim,
Try this. Select the columns you want to change, and simply search and replace . with 0.  Make sure to select "Match whole words only" and "Restrict to selected columns" and "search Data".  IT worked for me in a mock data set.
 
Cheers
Gunter
 

-----Original Message-----
From: jmp-l-owner@lists.biostat.wustl.edu [mailto:jmp-l-owner@lists.biostat.wustl.edu]On Behalf Of James T Metz
Sent: Tuesday, 12 July 2005 8:12 AM
To: jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: [jmp-l] Zero filling a subset of a JMP table



JMP Users, 

        Does anyone know of an efficient way to zero fill a subset of a JMP data table? 

        Specifics: 

        1)  I have a set of columns which are grouped together and are partially filled 
with data.  I would like to fill the remaining cells with blanks so that JMP will read the 
zeroes as data, rather than as a missing value. 

        Is there an efficient way to do this for several hundred columns?  I know how 
to do this for a few columns at a time using formulas for each individual column, but I do 
not know of a way to do this for hundreds of columns. 

        I would be most grateful to anyone willing to share 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.



****************************************************************************************************************
This email and any attached files are intended solely for the named addressee, are confidential and may contain legally privileged information. The copying or distribution of them or any information they contain, by anyone other than the addressee, is prohibited.  If you have received this email in error, please let us know by telephone or return the email to the sender
and destroy all copies. Thank you.

CSL Limited A.C.N. 051 588 348
45 Poplar Road Parkville Victoria 3052 Australia
Phone: +61 3 9389 1911  Fax: +61 3 9389 1434
***************************************************************************************************************