RE: [Suggest] NONMEM adds UTF-8 support for csv files
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’t 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: [email protected]
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: [email protected] <[email protected]> On Behalf Of
HUI, Ka Ho
Sent: Monday, June 4, 2018 4:48 AM
To: Mark Tepeck <[email protected]>; [email protected]
Subject: [FORGED] [NMusers] 回覆: [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
------ 原有訊息------
寄件者： Mark Tepeck
日期: 2018年6月4日週一 10:41
收件者： [email protected]<mailto:[email protected]>;
副本：
主旨：[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 “ID”, 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, '‘ID’. 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