* Export full org-mode to CSV (not tables)
@ 2009-08-24 12:29 Simon Mullis
2009-08-24 20:06 ` OrgmodeExport " Wes Hardaker
0 siblings, 1 reply; 3+ messages in thread
From: Simon Mullis @ 2009-08-24 12:29 UTC (permalink / raw)
To: emacs-orgmode
Hi All,
I now use org-mode for everthing I can. Unfortunately, the rest of
the world is still stuck in Excel-land.
I have a long and detailed org file for each project arranged as follows:
* Priority 1:
** Project: <name>
*** Number: <number>
*** Key1: <value1>
*** Key2: <value2>
*** Key3: <long multi-line text comment - value3>
* Priority 2:
** Project: <name>
*** Number: <number>
*** Key1: <value1>
*** Key2: <value2>
*** Key3: <long multi-line text comment - value3>
and so on. There are multiple "Projects" per "Priority". There may be
multiple "Numbers" per "Project".
I'd like an easy way to export this data to an Excel table, or better yet, CSV.
So,
Priority,Project, Number, Key1, Key2, Key3
<priority>,<name>, <number>, <value1>, <value2>, <value3>,
<priority>,<name>, <number>, <value1>, <value2>, <value3>,
and so on....
Ideally I'd like to do this from within org-mode. (Alternatively I can
just write some quick python (or whatever) to do this for me.)
Any ideas?
Thanks
SM
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: OrgmodeExport full org-mode to CSV (not tables)
2009-08-24 12:29 Export full org-mode to CSV (not tables) Simon Mullis
@ 2009-08-24 20:06 ` Wes Hardaker
2009-08-25 6:47 ` Simon Mullis
0 siblings, 1 reply; 3+ messages in thread
From: Wes Hardaker @ 2009-08-24 20:06 UTC (permalink / raw)
To: Simon Mullis; +Cc: emacs-orgmode
>>>>> On Mon, 24 Aug 2009 14:29:33 +0200, Simon Mullis <simon@mullis.co.uk> 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 http://pontifications.hardakers.net /
\_____ "In the bathtub of history the truth is harder to hold than ________/
\_______ the soap, and much more difficult to find." _______/
\_________ -- Terry Pratchett ______________/
\__________________/
^ permalink raw reply [flat|nested] 3+ messages in thread* Re: OrgmodeExport full org-mode to CSV (not tables)
2009-08-24 20:06 ` OrgmodeExport " Wes Hardaker
@ 2009-08-25 6:47 ` Simon Mullis
0 siblings, 0 replies; 3+ messages in thread
From: Simon Mullis @ 2009-08-25 6:47 UTC (permalink / raw)
To: Wes Hardaker; +Cc: emacs-orgmode
Thanks Wes. I'll try this...
Cheers
SM
2009/8/24 Wes Hardaker <wjhns209@hardakers.net>:
>>>>>> On Mon, 24 Aug 2009 14:29:33 +0200, Simon Mullis <simon@mullis.co.uk> 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 http://pontifications.hardakers.net /
> \_____ "In the bathtub of history the truth is harder to hold than ________/
> \_______ the soap, and much more difficult to find." _______/
> \_________ -- Terry Pratchett ______________/
> \__________________/
>
--
Simon Mullis
_________________
simon@mullis.co.uk
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2009-08-25 6:47 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2009-08-24 12:29 Export full org-mode to CSV (not tables) Simon Mullis
2009-08-24 20:06 ` OrgmodeExport " Wes Hardaker
2009-08-25 6:47 ` Simon Mullis
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).