From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Table formula to convert hex to dec
Date: Sun, 24 Jul 2011 11:52:32 +0200
Message-ID: <CALn3zohQ0ETsoCt-e60yzDrP-DOwp=qVUWztCgdTwyfhc+4M_A@mail.gmail.com>
References: <20110724080054.GB16388@x201>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:39174)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QkvMR-0000cm-A3
	for emacs-orgmode@gnu.org; Sun, 24 Jul 2011 05:52:35 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QkvMQ-00029Y-CA
	for emacs-orgmode@gnu.org; Sun, 24 Jul 2011 05:52:35 -0400
Received: from mail-wy0-f169.google.com ([74.125.82.169]:36131)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QkvMQ-00029U-1L
	for emacs-orgmode@gnu.org; Sun, 24 Jul 2011 05:52:34 -0400
Received: by wyg36 with SMTP id 36so2751870wyg.0
	for <emacs-orgmode@gnu.org>; Sun, 24 Jul 2011 02:52:33 -0700 (PDT)
In-Reply-To: <20110724080054.GB16388@x201>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: </archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hi Russell

On Sun, Jul 24, 2011 at 10:00, Russell Adams <RLAdams@adamsinfoserv.com> wrote:
> Has anyone been able to convert a column of hex numbers to decimal in
> another column?

Emacs Calc has a radix syntax "2#10" to "36#10", so this works:
| 16#10 | 16 | 16#10 |
#+TBLFM: $2 = $1 :: $3 = '(format "16#%x" $2); N

It would be nice to have not only "N" for the Org table formula mode
string like now but also optionally all possible Emacs Calc radix, so
the above would be simply (does not work yet):
| 16#10 | 16 | 16#10 |
#+TBLFM: $2 = $1 :: $3 = $2; N16#

Michael