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

From: Paul Hutson Date: March 14, 2019 technical Source: mail-archive.com
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
Quoted reply history
From: [email protected] <[email protected]> On Behalf Of Sebastien Bihorel Sent: Thursday, March 14, 2019 4:23 PM To: Emmanuel Chigutsa <[email protected]> Cc: [email protected] 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" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]>, "Sebastien Bihorel" <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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