[R] Converting character to numeric using the package "XLConnect"

Jim Lemon drjimlemon at gmail.com
Thu Aug 31 00:00:32 CEST 2017


Hi Nelly,
Are you trying to convert hexadecimal to decimal?

 nrdf
      Setting Value
1  Parameters     a
2  Parameters     b
3  Parameters     c
4  Parameters     d
5  Parameters     e
6  Parameters     2
7  Parameters     8
8  Parameters     9
9  Parameters     7
10          1     a
11          2     b
12          3     c
13          4     d

strtoi(nrdf$Value,16)
 [1] 10 11 12 13 14  2  8  9  7 10 11 12 13

Jim

On Thu, Aug 31, 2017 at 6:30 AM, Nelly Reduan <nell.redu at hotmail.fr> wrote:
> The Excel file can be found from this link: https://1drv.ms/x/s!Apkg2VlgfYyDgQ_mcJ8F4CaXV_Nh



More information about the R-help mailing list