From: Christopher Howard <cmhoward2@alaska.edu>
To: help-gnu-emacs@gnu.org
Subject: Re: exporting nested list to CSV file
Date: Tue, 22 Jul 2014 14:25:17 -0800 [thread overview]
Message-ID: <20140722142517.3a7bee43@voltron.arsc.edu> (raw)
In-Reply-To: <87oawhchko.fsf@gmail.com>
On Tue, 22 Jul 2014 21:35:35 +0200
Thorsten Jolitz <tjolitz@gmail.com> wrote:
> Christopher Howard <cmhoward2@alaska.edu> writes:
>
> > Hi. I've been using the pcsv library to parse data from external CSV
> > files, then using various elisp functions to filter/munge the
> > data. Afterwards, I was sad to discover that pcsv does not have any
> > functions for /writing/ data back to a CSV file.
> >
> > Since the data is well-structured, presumably this shouldn't be hard
> > to do. Could I get some guidance on what would be the simplest
> > approach? Is there another library I've overlooked? Or some
> > built-ins that would be especially helpful? The data are in lists
> > like so:
> >
> > (("row0datastring", "row0datastring", "row0datastring", ...)
> > ("row1datastring", "row1datastring", "row1datastring", ...)
> > ...
> > )
>
> try something like:
>
> #+begin_src emacs-lisp
> (mapconcat
> 'identity
> (append
> '("row0datastring" "row0datastring" "row0datastring")
> '("row1datastring" "row1datastring" "row1datastring")) ",")
> #+end_src
>
> #+results:
> :
> row0datastring,row0datastring,row0datastring,row1datastring,row1datastring,row1datastring
>
Thank you for helping me get started. I also needed to address the
issues of 1) newlines at the end of rows and 2) character escaping. To
address the second issue, I used "prin1", which I hope is a good
enough hack for my purposes:
#+begin_src emacs-lisp
(defun to-csv-row (fields)
(mapconcat 'prin1-to-string fields ","))
(defun to-csv-string (nested-list)
(mapconcat 'to-csv-row nested-list "\n"))
(defun to-csv-file (path nested-list)
"Converts NESTED-LIST to csv format and exports to file. NESTED-LIST is
expected to be the structure provided by the pcsv library."
(with-temp-file path
(insert (to-csv-string nested-list))))
#+end_src
next prev parent reply other threads:[~2014-07-22 22:25 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-07-22 18:52 exporting nested list to CSV file Christopher Howard
2014-07-22 19:35 ` Thorsten Jolitz
2014-07-22 22:25 ` Christopher Howard [this message]
2014-07-22 23:59 ` Christopher Howard
2014-07-23 6:19 ` Nicolas Richard
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.gnu.org/software/emacs/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20140722142517.3a7bee43@voltron.arsc.edu \
--to=cmhoward2@alaska.edu \
--cc=help-gnu-emacs@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.
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).