From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: org table with datestamp convert to csv and then xlsx or ods: problem Date: Mon, 08 Jan 2018 15:32:01 +0100 Message-ID: <87bmi45sm6.fsf@nicolasgoaziou.fr> References: <87373hzk6z.fsf@mat.ucm.es> <87incc5vvi.fsf@nicolasgoaziou.fr> <877essxx8y.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35473) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eYYT6-0005Ut-Sm for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 09:32:05 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eYYT5-0008Lc-Qk for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 09:32:04 -0500 Received: from relay2-d.mail.gandi.net ([2001:4b98:c:538::194]:40512) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1eYYT5-0008Ki-LA for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 09:32:03 -0500 Received: from saiph.selenimh (000043010000000000000469.ipv6.commingeshautdebit.fr [IPv6:2a03:a0a0:0:4301::469]) (Authenticated sender: mail@nicolasgoaziou.fr) by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id C4651C5A46 for ; Mon, 8 Jan 2018 15:32:01 +0100 (CET) Received: from ngz by saiph.selenimh with local (Exim 4.89) (envelope-from ) id 1eYYT3-0003PQ-5h for emacs-orgmode@gnu.org; Mon, 08 Jan 2018 15:32:01 +0100 In-Reply-To: <877essxx8y.fsf@mat.ucm.es> (Uwe Brauer's message of "Mon, 08 Jan 2018 15:04:29 +0100") 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 Uwe Brauer writes: > > Hello, > > Uwe Brauer writes: > > > > None. The export to CSV looks correct and complete. Conversion to CSV > > does not pretend converting anything else, in particular timestamps, to > > another format. > > Ok, > > Now how could that be achieved? I seem not the only one missing that a > feature. > https://lists.gnu.org/archive/html/emacs-orgmode/2016-11/msg00398.html For example: (defun my-format-timestamps (cell) (org-quote-csv-field (replace-regexp-in-string org-ts-regexp-both "\\1" cell))) (defun my-tbl-to-csv (table params) (orgtbl-to-csv table (org-combine-plists '(:fmt my-format-timestamps) params)))