How to format output table as purely comma-separated file

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

From: 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 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

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 [ mailto:Robert.Bauer_at_iconplc.com | Robert.Bauer_at_iconplc.com ] [ http://www.iconplc.com/ | www.iconplc.com ] From: 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 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 < [ mailto:paul.hutson_at_wisc.edu | 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: [ mailto:owner-nmusers_at_globomaxnm.com | owner-nmusers_at_globomaxnm.com ] < [ mailto: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 < [ mailto:echigutsa_at_yahoo.com | echigutsa_at_yahoo.com ] > Cc: [ mailto:nmusers_at_globomaxnm.com | 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" < [ mailto:echigutsa_at_yahoo.com | echigutsa_at_yahoo.com ] > To: [ mailto:nmusers_at_globomaxnm.com | nmusers_at_globomaxnm.com ] , "Sebastien Bihorel" < [ mailto:sebastien.bihorel_at_cognigencorp.com | 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 < [ mailto:sebastien.bihorel_at_cognigencorp.com | 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

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> 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