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.holf...@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-nmus...@globomaxnm.com <owner-nmus...@globomaxnm.com> *On > Behalf Of *Sebastien Bihorel > *Sent:* Tuesday, 19 March 2019 1:23 PM > *To:* Robert Bauer <robert.ba...@iconplc.com> > *Cc:* nmusers@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.ba...@iconplc.com> > *To: *nmusers@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.ba...@iconplc.com > > www.iconplc.com > > > > *From:* owner-nmus...@globomaxnm.com [mailto:owner-nmus...@globomaxnm.com > <owner-nmus...@globomaxnm.com>] *On Behalf Of *Mark Tepeck > *Sent:* Saturday, March 16, 2019 10:33 AM > *To:* nmusers@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.hut...@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-nmus...@globomaxnm.com <owner-nmus...@globomaxnm.com> *On > Behalf Of *Sebastien Bihorel > *Sent:* Thursday, March 14, 2019 4:23 PM > *To:* Emmanuel Chigutsa <echigu...@yahoo.com> > *Cc:* nmusers@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" <echigu...@yahoo.com> > *To: *nmusers@globomaxnm.com, "Sebastien Bihorel" < > sebastien.biho...@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.biho...@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 > >