Hi!
Is it possible to just avoid have anything in those columns also, just
replace the "." with an empty cell ? When exporting
(saving tables) sometimes those "." can be a nuisance in other programs.
Best wishes
Christer W
-----Original Message-----
From: James T Metz [mailto:james.metz@abbott.com]
Sent: tisdag, juli 12, 2005 01:27
To: jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: Re: [jmp-l] Zero filling a subset of a JMP table
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
****************************************************************************
***********************************
<<application/ms-tnef>>
|