From: Stefan Huchler <stefan.huchler@mail.de>
To: emacs-orgmode@gnu.org
Subject: Re: how to force org-mode to interpret number as string
Date: Fri, 07 Mar 2014 15:10:16 +0100 [thread overview]
Message-ID: <87iorqksl3.fsf@mars.lan> (raw)
In-Reply-To: 87k3c6vaff.fsf@gmail.com
Eric Schulte <schulte.eric@gmail.com> writes:
> I suggested that you remove "." from your numbers. You could also wrap
> your numbers in "s.
> #+name: example
> | "100.00000000" |
> #+begin_src emacs-lisp :var example=example
> (caar example)
> #+end_src
>
> #+RESULTS:
> : 100.00000000
>
thank you and sorry for my inpatiance.
That is a very helpful and constructive post.
And basicly that was one thing I searched that you can mark somehow
numbers as strings.
To rename the numbers that would work of course I just want a option
that works in any case, its not supposed to be a one-thing solution for
one problem, I want it to be usable for every data.
As a general serial mail tool, so renaming the numbers is no real good
solution, and the point on the thausends is pretty common here in
germany.
I dont need to use calc functionality in any way on this table, so I
don´t need proper number recognition besided if I need string its stupid
to first convert it to a number from string to convert it then back.
Especialy with all the "if (is number...)" block, and your mapping would
then also not work, because I have to check then every entry by 2 loops
like I did.
So to complete your solution, is there a way to wrap "" around of all
values in a table (or only on numbers)?
something like:
#tblfm: $3 = "$3" (or for all columns?)
Then I think I am satisfied ;)
>
> I would argue that the list of lists representation is indeed more
> commonly useful than converting a table to a list of dictionaries keyed
> by the header row. Maybe you will find the following helpful.
>
> #+TBLNAME: jobs
> | jobname | city | salary | email |
> | Taxi-driver | New York City | 500.000 | mayor@gotham-city.com |
> | Butcher | Peking | 5.000 | Jinping@china.cn |
>
> #+name: table-w-headers-to-list-of-key-value
> #+begin_src emacs-lisp :var data='()
> (let ((keys (car data))
> (vals (cdr data)))
> (mapcar (lambda (row) (map 'list #'cons keys row)) vals))
> #+end_src
>
> Example usage, pull the email from each value.
> #+begin_src emacs-lisp :var data=table-w-headers-to-list-of-key-value(jobs)
> (mapcar (lambda (row) (cdr (assoc "email" row))) data)
> #+end_src
>
> #+RESULTS:
> | mayor@gotham-city.com | Jinping@china.cn |
thanx yes the problem is that I am not so used to the lambda construct,
and I did not want to learn that and a new language at the same time,
but yes I should get used to map methods and lambda.
It´s a bit shorter yes. thanks!
next prev parent reply other threads:[~2014-03-07 14:10 UTC|newest]
Thread overview: 8+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-03-05 3:45 how to force org-mode to interpret number as string Stefan Huchler
2014-03-05 15:09 ` Bastien
2014-03-05 21:06 ` Stefan Huchler
2014-03-06 17:14 ` Eric Schulte
2014-03-07 4:12 ` Stefan Huchler
2014-03-07 5:34 ` Eric Schulte
2014-03-07 14:10 ` Stefan Huchler [this message]
2014-03-13 14:37 ` Bastien
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87iorqksl3.fsf@mars.lan \
--to=stefan.huchler@mail.de \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).