From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Loris Bennett" Subject: Import CSV file, remove columns, print table Date: Fri, 13 Sep 2019 15:33:33 +0200 Message-ID: <87r24knwwi.fsf@hornfels.zedat.fu-berlin.de> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:37151) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1i8lhp-00020k-OU for emacs-orgmode@gnu.org; Fri, 13 Sep 2019 09:33:46 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1i8lho-00024A-GL for emacs-orgmode@gnu.org; Fri, 13 Sep 2019 09:33:45 -0400 Received: from 195-159-176-226.customer.powertech.no ([195.159.176.226]:55858 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1i8lho-00022e-1M for emacs-orgmode@gnu.org; Fri, 13 Sep 2019 09:33:44 -0400 Received: from list by blaine.gmane.org with local (Exim 4.89) (envelope-from ) id 1i8lhk-0013B1-Ra for emacs-orgmode@gnu.org; Fri, 13 Sep 2019 15:33:40 +0200 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" To: emacs-orgmode@gnu.org Hi, I want to create a list of participants of an event which people can sign, so that I can record who actually turned up. >From the registration website I can download a CSV file and import it into and org file: | ID | Name | Titel / Title | Vorname / First Name | Nachname / Surname | Institution | | 1 | Alice Apple | Fr./Ms. | Alice | Apple | Universität zum Apfel | | 2 | Bob Birne | Hr./Mr. | Bob | Birne | Pear University | | 3 | Carol Carrot | Prof. | Carol | Carrot | University of Veg | I would like to reduce this to | ID | Nachname / Surname | Vorname / First Name | Signature | | 1 | Apple | Alice | | | 2 | Birne | Bob | | | 3 | Carrot | Carol | | and then print it out as a LaTeX table. I can obviously write a source block of Python or R to do this, but can I manipulate the table more directly in Org? Cheers, Loris -- This signature is currently under construction.