From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stefan Huchler Subject: Re: how to force org-mode to interpret number as string Date: Fri, 07 Mar 2014 05:12:38 +0100 Message-ID: <87r46elk95.fsf@mars.lan> References: <87siqx9um0.fsf@mars.lan> <871tygptqa.fsf@bzg.ath.cx> <87ha7c9xdn.fsf@mars.lan> <87lhwnug5t.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:54881) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WLm9X-0002xL-Q8 for emacs-orgmode@gnu.org; Thu, 06 Mar 2014 23:13:01 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WLm9S-000427-Ip for emacs-orgmode@gnu.org; Thu, 06 Mar 2014 23:12:55 -0500 Received: from plane.gmane.org ([80.91.229.3]:59411) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WLm9S-000420-Bf for emacs-orgmode@gnu.org; Thu, 06 Mar 2014 23:12:50 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1WLm9R-0001hO-Am for emacs-orgmode@gnu.org; Fri, 07 Mar 2014 05:12:49 +0100 Received: from hsi-kbw-109-193-108-156.hsi7.kabel-badenwuerttemberg.de ([109.193.108.156]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 07 Mar 2014 05:12:49 +0100 Received: from stefan.huchler by hsi-kbw-109-193-108-156.hsi7.kabel-badenwuerttemberg.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 07 Mar 2014 05:12:49 +0100 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 Eric Schulte writes: > Stefan Huchler writes: > >> Bastien writes: >> >>> Hi Stefan, >>> >>> Stefan Huchler writes: >>> >>>> The Problem is that that org-mode seems to auto-format the salary column >>>> as a number. >>> >>> That a problem here, but I guess this is handy in many circumstances. >>> >>> Why don't use just turn the number into a string in your code? >> >> if I could do that, without loosing the numbers behind the point I would >> be ok with that, but I dont want a fixed system for 1 table, but for a >> random table. >> > > I think that for this to work you may have to abandon using "." as your > numerical thousands separator. Or customize string-to-number and > org-babel-number-p to fit your number syntax. > > Best, I think the way I have to go is to use export the table to csv then it looses some of its "cleverness" and does what it should do in the first place. Hmm I just thought a second, maybe it does also do that data-manipulation also before it exports it, but no org-table-export does export it like a string. So here you have one bug, its inconsistent. So yes the easiest workaround is most likely to export it to a csv in /tmp/... and then parse it back ^^. Again I am suprised that there is no serial-mail package for emacs, then I would not even have to write this code. Sorry that I am maybe not so constructive but it´s stuff that should work and now you say that I should fix that upstream with me having written 50 lines of lisp code in my life. And how big are the chances that it gets included, when you people do not even consider that as a bug / needed feature. But sorry I really flame to much, I just find some stuff really stupid, as example why did I need to make out of a table a dict in the first place to put it into a list with lists is really stupid, dicts are more confortable I know in elisp maybe it has another name, but its similar and even in python I get no list of dicts (lines). Is it because of monstroses big Tables and performance problems? Sorry I can´t stopp. Still there is much great stuff there. Else I would not try to migrate my life into emacs ^^ ;)