From: Thierry Banel <tbanelwebmin@free.fr>
To: emacs-orgmode@gnu.org
Subject: [ANN] orgtbl-join
Date: Thu, 22 Jan 2015 22:03:47 +0100 [thread overview]
Message-ID: <54C165B3.5090407@free.fr> (raw)
Hi The List
I am glad to announce the orgtbl-join package.
It merges Org tables. A master table is enriched with material from a
reference table.
Example. This master table is a cooking recipe, with ingredients
and quantities (gramms).
| food | quty |
|----------+------|
| onion | 70 |
| tomatoe | 120 |
| eggplant | 300 |
| tofu | 100 |
| corn | 250 |
| tomatoe | 90 |
We also have a reference table of nutrition facts (freely borrowed
from Nut-Nutrition, http://nut.sourceforge.net/, by Jim Jozwiak).
#+tblname: nut
| food | Fiber | Sugar | Protein | Carb |
|----------+-------+-------+---------+------|
| eggplant | 2.5 | 3.2 | 0.8 | 8.6 |
| tomatoe | 0.6 | 2.1 | 0.8 | 3.4 |
| onion | 1.3 | 4.4 | 1.3 | 9.0 |
| egg | 0 | 18.3 | 31.9 | 18.3 |
| rice | 0.2 | 0 | 1.5 | 16.0 |
| bread | 0.7 | 0.7 | 3.3 | 16.0 |
| orange | 3.1 | 11.9 | 1.3 | 17.6 |
| banana | 2.1 | 9.9 | 0.9 | 18.5 |
| tofu | 0.7 | 0.5 | 6.6 | 1.4 |
| nut | 2.6 | 1.3 | 4.9 | 7.2 |
| corn | 4.7 | 1.8 | 2.8 | 21.3 |
Then, typing M-x orgtbl-join, the recipe get enriched with nutrition
facts:
| food | quty | Fiber | Sugar | Protein | Carb |
|----------+------+-------+-------+---------+------|
| onion | 70 | 1.3 | 4.4 | 1.3 | 9.0 |
| tomatoe | 120 | 0.6 | 2.1 | 0.8 | 3.4 |
| eggplant | 300 | 2.5 | 3.2 | 0.8 | 8.6 |
| tofu | 100 | 0.7 | 0.5 | 6.6 | 1.4 |
| corn | 250 | 4.7 | 1.8 | 2.8 | 21.3 |
| tomatoe | 90 | 0.6 | 2.1 | 0.8 | 3.4 |
Documentation here:
https://github.com/tbanel/orgtbljoin
---------
Tha package is available on MELPA.
To enable MELPA, add those lines to your .emacs:
(require 'package)
(add-to-list
'package-archives
'("melpa" . "http://melpa.milkbox.net/packages/") t)
(package-initialize)
Then browse the 2000 available packages (and growing)
by typing:
M-x package-list-packages
Comments, use-cases, help, criticisms, etc. welcome.
Have fun
Thierry Banel
next reply other threads:[~2015-01-22 21:03 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2015-01-22 21:03 Thierry Banel [this message]
2015-01-23 2:21 ` [ANN] orgtbl-join Eric Abrahamsen
2015-08-05 0:00 ` Bastien Guerry
2015-08-16 21:57 ` Thierry Banel
2015-08-18 15:22 ` Bastien
2015-08-20 21:04 ` Thierry Banel
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=54C165B3.5090407@free.fr \
--to=tbanelwebmin@free.fr \
--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).