From mboxrd@z Thu Jan 1 00:00:00 1970 From: Simon Mullis Subject: Re: OrgmodeExport full org-mode to CSV (not tables) Date: Tue, 25 Aug 2009 08:47:28 +0200 Message-ID: <23d7e1bb0908242347r35bc805p9d9f98e68d6d5f0c@mail.gmail.com> References: <23d7e1bb0908240529s61574804i18cea3dd4630b500@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Mfpof-0008P7-V2 for emacs-orgmode@gnu.org; Tue, 25 Aug 2009 02:47:37 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Mfpob-0008Kw-7Q for emacs-orgmode@gnu.org; Tue, 25 Aug 2009 02:47:37 -0400 Received: from [199.232.76.173] (port=56108 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Mfpob-0008Kp-42 for emacs-orgmode@gnu.org; Tue, 25 Aug 2009 02:47:33 -0400 Received: from mx20.gnu.org ([199.232.41.8]:57254) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1Mfpoa-0006Zo-GN for emacs-orgmode@gnu.org; Tue, 25 Aug 2009 02:47:32 -0400 Received: from mail-fx0-f226.google.com ([209.85.220.226]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MfpoZ-0000EM-Sv for emacs-orgmode@gnu.org; Tue, 25 Aug 2009 02:47:32 -0400 Received: by fxm26 with SMTP id 26so2470405fxm.42 for ; Mon, 24 Aug 2009 23:47:29 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Wes Hardaker Cc: emacs-orgmode@gnu.org Thanks Wes. I'll try this... Cheers SM 2009/8/24 Wes Hardaker : >>>>>> On Mon, 24 Aug 2009 14:29:33 +0200, Simon Mullis said: > > SM> I'd like an easy way to export this data to an Excel table, or > SM> better yet, CSV. > > org-export-generic can *almost* do this for you by carefully setting the > header open/close to simply be ", " for opening and a "\n" for closing > on header 2 (I think; haven't tested it). > > But, it won't remove the text: prefix at the beginning of the fields. > It' be simple to pass the results through sed 's/, [^:]*:/,/g' though. > -- > \ Wes Hardaker =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 http:/= /pontifications.hardakers.net / > =A0\_____ "In the bathtub of history the truth is harder to hold than ___= _____/ > =A0 =A0 =A0 \_______ the soap, and much more difficult to find." _______/ > =A0 =A0 =A0 =A0 =A0 =A0 =A0 \_________ -- Terry Pratchett ______________/ > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 \__________________/ > --=20 Simon Mullis _________________ simon@mullis.co.uk