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

From: Mark Tepeck <mark.tepeck_at_gmail.com>
Date: Mon, 18 Mar 2019 21:25:45 -0400

I vote for *FORMAT=CSV*, which reads super intuitive and handy. I would
even expect it to be the default although this change sounds crazy for the
time being.

Mark

On Mon, Mar 18, 2019 at 8:50 PM Nick Holford <n.holford_at_auckland.ac.nz>
wrote:

> 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>
> *To: *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
>
> www.iconplc.com
>
>
>
> *From:* owner-nmusers_at_globomaxnm.com [mailto:owner-nmusers_at_globomaxnm.com
> <owner-nmusers_at_globomaxnm.com>] *On Behalf Of *Mark Tepeck
> *Sent:* Saturday, March 16, 2019 10:33 AM
> *To:* 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> 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 <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>
> *Cc:* 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>
> *To: *nmusers_at_globomaxnm.com, "Sebastien Bihorel" <
> 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> 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 - 21:25:45 EDT

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