NONMEM Users Network Archive

Hosted by Cognigen

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

From: Paul Hutson <paul.hutson_at_wisc.edu>
Date: Thu, 14 Mar 2019 22:19:28 +0000

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



Received on Thu Mar 14 2019 - 18:19:28 EDT

The NONMEM Users Network is maintained by ICON plc. Requests to subscribe to the network should be sent to: nmusers-request_at_iconplc.com. Once subscribed, you may contribute to the discussion by emailing: nmusers@globomaxnm.com.