Re: [O] Table formula to convert hex to dec

[Nick Dokos]

Russell Adams <address@hidden> wrote:

> Has anyone been able to convert a column of hex numbers to decimal in
> another column?
> 

I suspect there are many ways - here's one:

--8<---------------cut here---------------start------------->8---
* hex-to- conversion

|  h |  d |  o |
|----+----+----|
|  1 |  1 |  1 |
|  2 |  2 |  2 |
|  3 |  3 |  3 |
|  4 |  4 |  4 |
|  5 |  5 |  5 |
|  6 |  6 |  6 |
|  7 |  7 |  7 |
|  8 |  8 | 10 |
|  9 |  9 | 11 |
|  a | 10 | 12 |
|  b | 11 | 13 |
|  c | 12 | 14 |
|  d | 13 | 15 |
|  e | 14 | 16 |
|  f | 15 | 17 |
| 10 | 16 | 20 |
| 11 | 17 | 21 |
| 12 | 18 | 22 |
| 13 | 19 | 23 |
| 14 | 20 | 24 |
| 15 | 21 | 25 |
| 16 | 22 | 26 |
#+TBlLFM: $2 = '(string-to-number $1 16) :: $3 = '(string-to-number $1 16);%o
--8<---------------cut here---------------end--------------->8---

Nick