RE: [Suggest] NONMEM adds UTF-8 support for csv files(B
Hi,
Excel can open files with ID as the first column header. You just have to agree to continue when Excel shows its warning messages.
Personally I use #ID as the first column header which avoids the Excel warnings and also means I don$B!G(Bt need to specify an IGNORE character in NM-TRAN because # is the default.
Best wishes,
Nick
--
Nick Holford, Professor Clinical Pharmacology
Dept Pharmacology & Clinical Pharmacology, Bldg 503 Room 302A
University of Auckland,85 Park Rd,Private Bag 92019,Auckland,New Zealand
office:+64(9)923-6730 mobile:NZ+64(21)46 23 53 FR+33(6)62 32 46 72
email: n.holford_at_auckland.ac.nz
http://holford.fmhs.auckland.ac.nz/
http://orcid.org/0000-0002-4031-2514
Read the question, answer the question, attempt all questions
Quoted reply history
From: owner-nmusers_at_globomaxnm.com <owner-nmusers_at_globomaxnm.com> On Behalf Of HUI, Ka Ho
Sent: Monday, June 4, 2018 4:48 AM
To: Mark Tepeck <mark.tepeck_at_gmail.com>; nmusers_at_globomaxnm.com
Subject: [FORGED] [NMusers] $B2sJ$(B: [NMusers] [Suggest] NONMEM adds UTF-8 support for csv files
Dear Mark
Does it work if you don't put "ID" as the first column? Back to the days when I frequently used Excel, this had been the solution for me.
Matthew
------ $B86M-?VB)(B------
$B4s7o<T!'(B Mark Tepeck
$BF|4|(B: 2018$BG/(B6$B7n(B4$BF|Pl(B 10:41
$BZ_at_7o<T!'(B nmusers_at_globomaxnm.com<mailto:nmusers_at_globomaxnm.com>;
$BI{K\!'(B
$B<g;]!'(B[NMusers] [Suggest] NONMEM adds UTF-8 support for csv files
Hi NONMEM Users,
As a PK scientist, I often manipulate csv files with Microsoft Excel, R, and NONMEM. As some of you may have seen, if the first record in a csv file is a string $B!H(BID$B!I(B, Microsoft Excel would mistake it as an SYLK file which cannot be opened normally by Excel. One workaround is to use any strings other than ID, e.g. id, '$B!F(BID$B!G(B. However, this may cause new problems in some scenarios. Another potential solution is to use the R function readr::write_excel_csv ('dataframe.csv') to output a csv file with UTF-8 Byte order mark. Unfortunately, this csv file turned out to become unreadable for NONMEM although Excel likes it. Since waiting for bug fixing of Excel by Microsoft is not optimistic, I would truly appreciate it if NONMEM can add UTF-8 support.
Thank you,
Mark Tepeck