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
***************************************************************************************************************
|