RE: How to format output table as purely comma-separated file
Well, this is not a strange behavior, this is a standard FORTRAN formatting
process.
Nonetheless, I can add a delimiter option that specifically removes spaces for
future releases of NONMEM.
Robert J. Bauer, Ph.D.
Senior Director
Pharmacometrics R&D
ICON Early Phase
820 W. Diamond Avenue
Suite 100
Gaithersburg, MD 20878
Office: (215) 616-6428
Mobile: (925) 286-0769
[email protected]<mailto:[email protected]>
http://www.iconplc.com/
Quoted reply history
From: [email protected] [mailto:[email protected]] On
Behalf Of Mark Tepeck
Sent: Saturday, March 16, 2019 10:33 AM
To: [email protected]
Cc: Sebastien Bihorel; Emmanuel Chigutsa; Paul Hutson
Subject: Re: [NMusers] How to format output table as purely comma-separated file
Hi,
I am also wondering why NONMEM has this strange behavior. Is there any
possibility for the developer to fix that? at least to provide an option to
exclude the space.
Mark
On Thu, Mar 14, 2019 at 6:31 PM Paul Hutson
<[email protected]<mailto:[email protected]>> wrote:
Spaces as well, yes, but a simple click on the file opens nicely into EXCEL
without Data/Text Import. Thank you.
Paul Hutson, PharmD, BCOP
Professor
UWisc School of Pharmacy
T: 608.263.2496
F: 608.265.5421
From: [email protected]<mailto:[email protected]>
<[email protected]<mailto:[email protected]>> On Behalf
Of Sebastien Bihorel
Sent: Thursday, March 14, 2019 4:23 PM
To: Emmanuel Chigutsa <[email protected]<mailto:[email protected]>>
Cc: [email protected]<mailto:[email protected]>
Subject: Re: [NMusers] How to format output table as purely comma-separated file
Thanks for the input but I already tried that (or things along the line of
FORMAT=,1PE11.4). Commas are indeed in the table file... but so are spaces.
________________________________
From: "Emmanuel Chigutsa" <[email protected]<mailto:[email protected]>>
To: [email protected]<mailto:[email protected]>, "Sebastien Bihorel"
<[email protected]<mailto:[email protected]>>
Sent: Thursday, March 14, 2019 3:47:15 PM
Subject: Re: [NMusers] How to format output table as purely comma-separated file
Hi Sebastien,
Try the following example code, with the relevant pieces in red:
$TABLE ID TIME CMT IPRED FORMAT=, FILE=mytab1.csv NOPRINT ONEHEADER
Mannie
On Wednesday, March 13, 2019, 9:14:21 AM EDT, Sebastien Bihorel
<[email protected]<mailto:[email protected]>>
wrote:
Hi,
I was wondering if there is a way to create "pure" csv file with $TABLE. I have
tried various things with the FORMAT option but always ended up with spaces in
between entries (in addition to the comma delimiters).
Is there a proper fortran format one can use in $TABLE to make this happen?
Thanks in advance
Sebastien