From mboxrd@z Thu Jan  1 00:00:00 1970
From: John Kitchin <jkitchin@andrew.cmu.edu>
Subject: Re: extract a region from a table and export it
Date: Tue, 14 Jun 2016 07:19:39 -0400
Message-ID: <m260tc586s.fsf@Johns-MacBook-Air.local>
References: <87oa74vyma.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:49882)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <johnrkitchin@gmail.com>) id 1bCmNo-0006ot-1M
	for emacs-orgmode@gnu.org; Tue, 14 Jun 2016 07:19:49 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <johnrkitchin@gmail.com>) id 1bCmNk-0007GG-P1
	for emacs-orgmode@gnu.org; Tue, 14 Jun 2016 07:19:47 -0400
Received: from mail-qk0-x22f.google.com ([2607:f8b0:400d:c09::22f]:34078)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <johnrkitchin@gmail.com>) id 1bCmNk-0007G8-Jq
	for emacs-orgmode@gnu.org; Tue, 14 Jun 2016 07:19:44 -0400
Received: by mail-qk0-x22f.google.com with SMTP id s186so85704673qkc.1
	for <emacs-orgmode@gnu.org>; Tue, 14 Jun 2016 04:19:44 -0700 (PDT)
In-reply-to: <87oa74vyma.fsf@mat.ucm.es>
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: <http://lists.gnu.org/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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Uwe Brauer <oub@mat.ucm.es>
Cc: emacs-orgmode@gnu.org

can you write a little code block that filters the table for what you
want, and then convert that to a pdf?

Something like:


#+tblname: data
| 1 | a |
| 2 | r |
| 5 | 7 |
| 4 | 9 |
| 8 | y |

#+BEGIN_SRC emacs-lisp :var d=data
(orgtbl-to-csv (-filter (lambda (x) (and (> (car x) 2) (< (car x) 8))) d) nil)
#+END_SRC

#+RESULTS:
: 5,7
: 4,9

or, rows 0, 1 and 4.

#+BEGIN_SRC emacs-lisp :var d=data
(loop for i in '(0 1 4) collect (elt d i))
#+END_SRC

#+RESULTS:
| 1 | a |
| 2 | r |
| 8 | y |




Uwe Brauer writes:

> Hi
>
> Is it possible to extract just say two regions from a huge table and
> convert it to say CSV?
>
> Uwe Brauer


-- 
Professor John Kitchin
Doherty Hall A207F
Department of Chemical Engineering
Carnegie Mellon University
Pittsburgh, PA 15213
412-268-7803
@johnkitchin
http://kitchingroup.cheme.cmu.edu