emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Uwe Brauer <oub@mat.ucm.es>
To: emacs-orgmode@gnu.org
Subject: problem with lookup, count several string in one (or more) columns.
Date: Mon, 04 Jul 2016 19:57:39 +0000	[thread overview]
Message-ID: <877fd1b2h8.fsf@mat.ucm.es> (raw)



Hello

I tried to follow the instructions found in
http://orgmode.org/worg/org-tutorials/org-lookups.html

So I want to count all strings NP MH  in the following table
According to the instructions, the following will search the string MH.

| group | round 1 | round 2 |
|-------+---------+---------|
| A     |         |     2.4 |
| B     | 4.7     |      11 |
| C     |         |      MH |
| D     | 5       |         |
| E     |         |     7.2 |
| F     | 3.2     |     4.3 |
| G     | NP      |     4.4 |
| H     | NP      |       8 |
| I     | NP      |       8 |
|-------+---------+---------|
| total | MH      |       1 |
#+TBLFM: @>$3='(length(org-lookup-all "MH" '(@2$2..@-1$3) nil));

So I could repeat that for the string NP as well but how can I search
for both (or more) strings at once?

             reply	other threads:[~2016-07-04 19:57 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2016-07-04 19:57 Uwe Brauer [this message]
2016-07-05  6:50 ` problem with lookup, count several string in one (or more) columns Marco Wahl
2016-07-05 12:22   ` Uwe Brauer
2016-07-05 13:47     ` Marco Wahl
2016-07-05 14:53       ` Uwe Brauer

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=877fd1b2h8.fsf@mat.ucm.es \
    --to=oub@mat.ucm.es \
    --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).