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