RE: [NMusers] How to format output table as purely comma-separated file

From: Nick Holford <n.holford_at_auckland.ac.nz>
Date: Tue, 19 Mar 2019 00:38:46 +0000

Hi Bob,
I agree with Sebastien. This would be a useful option and even better if it was user friendly option like FORMAT=CSV which also converted from scientific format to general format (Excel format names).
Best wishes,
Nick

From: owner-nmusers_at_globomaxnm.com <owner-nmusers_at_globomaxnm.com> On Behalf Of Sebastien Bihorel
Sent: Tuesday, 19 March 2019 1:23 PM
To: Robert Bauer <Robert.Bauer_at_iconplc.com>
Cc: nmusers_at_globomaxnm.com
Subject: Re: [NMusers] How to format output table as purely comma-separated file

Hi,

I think it would be a very useful option!

Thanks

________________________________
From: "Robert Bauer" <Robert.Bauer_at_iconplc.com<mailto:Robert.Bauer_at_iconplc.com>>
To: nmusers_at_globomaxnm.com<mailto:nmusers_at_globomaxnm.com>
Sent: Monday, March 18, 2019 2:20:15 PM
Subject: RE: [NMusers] 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
Robert.Bauer_at_iconplc.com<mailto:Robert.Bauer_at_iconplc.com>
www.iconplc.com<http://www.iconplc.com/>

From: owner-nmusers_at_globomaxnm.com<mailto:owner-nmusers_at_globomaxnm.com> [mailto:owner-nmusers_at_globomaxnm.com] On Behalf Of Mark Tepeck
Sent: Saturday, March 16, 2019 10:33 AM
To: nmusers_at_globomaxnm.com<mailto:nmusers_at_globomaxnm.com>
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 <paul.hutson_at_wisc.edu<mailto:paul.hutson_at_wisc.edu>> 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: owner-nmusers_at_globomaxnm.com<mailto:owner-nmusers_at_globomaxnm.com> <owner-nmusers_at_globomaxnm.com<mailto:owner-nmusers_at_globomaxnm.com>> On Behalf Of Sebastien Bihorel
Sent: Thursday, March 14, 2019 4:23 PM
To: Emmanuel Chigutsa <echigutsa_at_yahoo.com<mailto:echigutsa_at_yahoo.com>>
Cc: nmusers_at_globomaxnm.com<mailto:nmusers_at_globomaxnm.com>
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" <echigutsa_at_yahoo.com<mailto:echigutsa_at_yahoo.com>>
To: nmusers_at_globomaxnm.com<mailto:nmusers_at_globomaxnm.com>, "Sebastien Bihorel" <sebastien.bihorel_at_cognigencorp.com<mailto:sebastien.bihorel_at_cognigencorp.com>>
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 <sebastien.bihorel_at_cognigencorp.com<mailto:sebastien.bihorel_at_cognigencorp.com>> 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




ICON plc made the following annotations.
------------------------------------------------------------------------------
This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this e-mail is strictly prohibited. If you have received this e-mail transmission in error, please reply to the sender, so that ICON plc can arrange for proper delivery, and then please delete the message.

Thank You,

ICON plc
South County Business Park
Leopardstown
Dublin 18
Ireland
Registered number: 145835



Received on Mon Mar 18 2019 - 20:38:46 EDT

This archive was generated by hypermail 2.3.0 : Fri Sep 27 2019 - 17:03:58 EDT