From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id gFDjLZlDUGfU9AAAqHPOHw:P1 (envelope-from ) for ; Wed, 04 Dec 2024 11:57:13 +0000 Received: from aspmx1.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id gFDjLZlDUGfU9AAAqHPOHw (envelope-from ) for ; Wed, 04 Dec 2024 12:57:13 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=NBIhpiAj; dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; arc=pass ("microsoft.com:s=arcselector10001:i=1") ARC-Seal: i=2; s=key1; d=yhetil.org; t=1733313433; a=rsa-sha256; cv=pass; b=ZrqpbUur+9LX9VqA5teoltBo4+LtuIGyhp21ypKI+M6DxZY5tmTSGxiHIJi9grMLCUsJ3i 80xyDuQ1aUUBSrtW5ztBMWGcpou4GyXhBpQZrgLvQuZzj0oSfMGbpB+3kRhU4VxN0GAlJj ljg1SFmbtjLyw5rIYKUUuls5zVCItdECErH/SJRQPc9HYveHRdfvRzePKGsl2KGVuId7iM v5Uz5rVBX5hiRr9K8yhGqSDeEgVUzf3i4j77vGfGwgL9T/2i0lczYp1rbIK8cnGs8lQg8R mDzD2jpgf7jNogmOCsmZDQn/Yy0MTFBIhm0EEJapUXAyzb/LEfCpH54sT8TUhA== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=NBIhpiAj; dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; arc=pass ("microsoft.com:s=arcselector10001:i=1") ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1733313433; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=atkILpgxyyBpiRYzNxHNZFnsgAUFUJRkY/vyVcVlk90=; b=l5H3mUfaTYc1bOeQtyNCYiTccPMLswQDMFi2cEp/ONxIFWvzQtEdANT1A2quhTeks41vdK k+QD3k+vtFqpypyS1ncSgD/g/7aTgHMrou12Lpd6D7SpHjM89xicMY30PIShQ8/JULM3Nf KEoajD0dzEaodLzvA8F9B3hucgUUm8+cPOlZG6/Oi4UraV/mepPO+tqmXBX/KgPV8TEFDr h+Gtbb+Ra/WV7K/OQ2PvLIx06jlBVSkFjQmVaVLCMH2mrpC9/BFXldWJYAkqa36Xbn1Chv W9gx+EGlqGWefwQBtxhRA5vZ0/6Wg3jA4j6XBiIuap8mWRiqnhIx4D4qY8X7Pg== Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 4C0BE6D01 for ; Wed, 04 Dec 2024 12:57:13 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1tInzK-0004kG-Sa; Wed, 04 Dec 2024 06:56:14 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tInzI-0004k3-Po for emacs-orgmode@gnu.org; Wed, 04 Dec 2024 06:56:12 -0500 Received: from mail-vi1eur03on2071d.outbound.protection.outlook.com ([2a01:111:f403:260c::71d] helo=EUR03-VI1-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tInzG-0002zI-PR for emacs-orgmode@gnu.org; Wed, 04 Dec 2024 06:56:12 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=v5iEPwEKU+aKqlYnfVO6Zt4+iYZwQgrTIgRi095KNsZ7XBnwkNP9gHbXJs2fMNHH+N2Jdk8/J9Cyqzgk/m5YAFIq3kq0SLhD82dpxILsLfrUQXFBq26bfTnFPExTx6YVebOFZZOdk/Ul3eNX7UbPY3j9pSRQZsOPAK0RzSvwS0YgNV1+r3GZEGWIwI7MrYhux+ojVNatXCCZ4skI6u4efiwobrgcs5uarqJCUXDMmK/gadHFBO0MwNG0Ldn2dBeNa3Cn8It7LPjtWpXBSuIqp7H65F8QBNK9xnaCe5/bl9gk9h9xxF2rxDdOWO9WcQbeqlmavmVzF7acnfoPPRIF3g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=atkILpgxyyBpiRYzNxHNZFnsgAUFUJRkY/vyVcVlk90=; b=H93aoESn5Yl9GT7VJjG4u/F3+f0C1v/dCRr7KzjiJ1xzntaiMzuEuXLK97+He/bsE4hpqjINSwDj+TAImk/c5O60bi3K7QeORWRcEKPg49qzlKED1XbJizjwfUuUJ0oPq7339DUbEzYFGtlPbIihKLtEPCLwl8+J55Fq4lBUO6hXNNgy97JeV2+n4db8B/Nm2HZP1fmsvsPhODUIZRj92EX3wYbK9fAadpUZvCdf1y4vJZHMzZWtnNFJ9EJBOdARk0W1ebHPF04LTsWqRTMLehOcpycWGa7GOBF790EGCZN92rQsYdWeg9VlSefeayNo4e3cQa8v1w/Jz8sUCNvxwQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucl.ac.uk; dmarc=pass action=none header.from=ucl.ac.uk; dkim=pass header.d=ucl.ac.uk; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucl.ac.uk; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=atkILpgxyyBpiRYzNxHNZFnsgAUFUJRkY/vyVcVlk90=; b=NBIhpiAj7lZsdkyI5AQhdnyg3IxHwDsXJIhjmokQ+xuTu4WlMRDrH6bYbM1D5D4iJQIwDHAy9paJn/ooUnPYLBuXRr53q90vmpLBD+QdBdT015GaRU+1sryvp5ErnqdjQnQk9aQFkEXiSngpVJOlgI4yTjjVZ4rjdZ9HqZ2mxk4= Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4fa::21) by AM9PR01MB8184.eurprd01.prod.exchangelabs.com (2603:10a6:20b:417::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8230.10; Wed, 4 Dec 2024 11:51:05 +0000 Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::6b8e:d43:e0fc:22e]) by AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::6b8e:d43:e0fc:22e%4]) with mapi id 15.20.8230.010; Wed, 4 Dec 2024 11:51:05 +0000 From: "Fraga, Eric" To: Michael Heerdegen CC: Org Mode List Subject: Re: Plotting a table of date+time pairs Thread-Topic: Plotting a table of date+time pairs Thread-Index: AQHbQTP3B8EKslNU+Eemyv2Fg+tMUA== Date: Wed, 4 Dec 2024 11:51:05 +0000 Message-ID: <87frn34qfr.fsf@ucl.ac.uk> References: <874j3snog0.fsf@web.de> <875xo7r9mu.fsf@ucl.ac.uk> <87mshj6j8z.fsf@web.de> <871pyu9ysj.fsf@ucl.ac.uk> <87wmglckjd.fsf@web.de> <87iks2qnr1.fsf@ucl.ac.uk> <87ser3pvr3.fsf@web.de> In-Reply-To: <87ser3pvr3.fsf@web.de> (Michael Heerdegen's message of "Wed, 04 Dec 2024 11:50:40 +0100") Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: gnus (Emacs 31.0.50) x-url: http://www.ucl.ac.uk/~ucecesf/ mail-followup-to: Org Mode List x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AS4PR01MB10249:EE_|AM9PR01MB8184:EE_ x-ms-office365-filtering-correlation-id: fd8ae220-3320-4f28-3c14-08dd1459ef06 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; ARA:13230040|1800799024|366016|376014|38070700018; x-microsoft-antispam-message-info: =?iso-8859-1?Q?tWwttj8brQpekBeOfQjyt5MiBfPelpa1OImhRZ5G5ijjewVUhPRCJZ8/ju?= =?iso-8859-1?Q?bEy7s1jd9XnUaQCtDUy+MPurqzMBIHnysZjtdTcUMLqbQt1KVL+Jpw4U/E?= =?iso-8859-1?Q?ZG+r8uxqJb+YzSGOWE8fOOCpDlVnCGtnItk4SvcRsM92mwq+Agtnq36Arg?= =?iso-8859-1?Q?JE6vBieiC1IQw6pgCarTPCRuQc7RxOn9XdmiqMxtALZf77A7tmWz9hQZtA?= =?iso-8859-1?Q?mFWnbcXwhOlE7yDmPhpFCyvygR56G8ygFNaD1avdiczeRYenIpG93vDEMW?= =?iso-8859-1?Q?ZnnuAW+HMLeG0qdh0801EsKd/mR3hfOZBwIlXzkWBR4H2NzySLiMnymBfQ?= =?iso-8859-1?Q?kxrQ1LnWRaDIt+JO3W9KIqg4uhItHRsK7frZJRP4aOtF87q1XuUqnm4fNj?= =?iso-8859-1?Q?KdQHMuTxHP8HS1Ov3WNFZe0QCYH99mK0juaBXc8h5vvfiwvDHc8vBYuI1p?= =?iso-8859-1?Q?2mBp5G5ie4msfC6xU33/ZjPd9tmJO9sNKbNTCe8U24jDvPw7B+XQN0Wv4n?= =?iso-8859-1?Q?QlO2tSTxKEYz0fC1X1DbJyGY5oGha3vyL2QVBRJEkXqD0VbryV1KVGl4NX?= =?iso-8859-1?Q?M17KehcH/2w6WtzJNbuzVXFanKa6PjIdjZGQZIUlSTomQKYUPBREcGXIvo?= =?iso-8859-1?Q?HNah1eaAmWuFpOjEYVlqDarCBiXxjGOEZHvDSUZEhJGEYO9Ha0ig6Go1yO?= =?iso-8859-1?Q?/Ixy1saVwH6p6RVMm62emXPCLld14oxQUqo5C5vUuhwzaKL/9fzu7WlcSD?= =?iso-8859-1?Q?X58Mk4Z1oyT9j3IUpzZ0bm9ZmD1H+ii+OEjX+TuQWz/eIoSpFi4AXEas8Q?= =?iso-8859-1?Q?V1XRPuBdB+KUanXEgrCb3liwUpHVbDmgwox+Fyd5Rzq7Zi2WaTDvioMSaV?= =?iso-8859-1?Q?o6fDyOPAyW7C9OUKbAhBC67S/HgQ09IPxsM5xWXYX2gMkierzw3rBbE5Jk?= =?iso-8859-1?Q?ihZ2+7u6y8qnYvQj4X2puwYibZOs85ketC32J830Dhy2+RLn2aqoxvjT+B?= =?iso-8859-1?Q?RPm9Q3YVHkky+9pCSLMtBApaAnXbE2KI2ah3p007iS/MsyEyZWqIWkToQS?= =?iso-8859-1?Q?PvaarqV3WRPHuo3EZPLbzXJxQYgqZ03hHBsJXr+NS+HZBitFvEaKAMhy12?= =?iso-8859-1?Q?W9Jp7RoYbkKsLRjH+rPL+n8cDNzzGA14didh0Nthlgj3gZIR629bILf4K3?= =?iso-8859-1?Q?h4Ic6SRTg4PojawlXplhpKT3/x39RE9QcwGNOMxJTh1+OkQfY2U7lFUYuo?= =?iso-8859-1?Q?92SKi9vwMhBLGPXkbcooqYxmTcO5gLk6Ar+nsEBrlin1mZHk4Bg/RVBie6?= =?iso-8859-1?Q?ODMc3Bu/gk/qZNQ0wrBGo4YhWquvuO8vdW+WzqAk2BSilc/cq3kpRaXO0J?= =?iso-8859-1?Q?E5qfs1vYH/YjfAiiYzYhrncTFAlfhhPFc2hxDlanG4yN/vBNCBP1jac0H7?= =?iso-8859-1?Q?UmulTrXjmClvH8Ua9N0djICJzqcXXNTfWJSSJQ=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:AS4PR01MB10249.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(13230040)(1800799024)(366016)(376014)(38070700018); DIR:OUT; SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?Wsm5gHhzayMNTvCOIG0GQO5ZXIcctqiAp2x5TiB5oOtZF0hmy5qiGG1Stt?= =?iso-8859-1?Q?ujBDjY16XkS1rfuyGwlwI2VRFj/0bFFrykzcFjjZk7VCxYK/a19na67MkI?= =?iso-8859-1?Q?98+ZJRiB29OFd1ikK5XDlzmfPmvowmsZ8qMVQv6vEJX9SR2rfbcvLpW1TI?= =?iso-8859-1?Q?TSE27A67oMqnZwofhnIzfnduI6QIu0O4tYBsFpKjQhQaSzJ7wjqlkS1Wdw?= =?iso-8859-1?Q?vcBJsSyNooM3ySBdmyssHTEbuz6VesxnXQI6pGY+RADWkX3m5EQ/gA4T/8?= =?iso-8859-1?Q?eM04ny8+xp0NrdHLi6Ze1lrSPVRfTi1Xdoo6yktoQXr1ApPpSL8fmUKW4g?= =?iso-8859-1?Q?8Hg6NpOwXDMGZKf7Y0TqbH/BeoOf5HNXBd9erOL8cUSWnPsCsNqz3gB4RS?= =?iso-8859-1?Q?V6/+P2N41aoIJVm+teePbRjC9LOMHEmqtz7tDSvXpMc6mRh5L3rg1HO1sm?= =?iso-8859-1?Q?vJ6G3fIiJyJMTI2sSKj3B2B8hA0n//kEf1wL9sJJVQY0y+rCOSm0MM+qHu?= =?iso-8859-1?Q?MDr1i127kirCeQc31XsapJVhkp/irApp34vbc/0qbSih8FcHTNKGlODp6i?= =?iso-8859-1?Q?lQCsmMgkBRWFRR3ZM9EFRGGMEySU/d1mSM+S++UG0BA3GoECataBdd/Hcy?= =?iso-8859-1?Q?BCKNblpDDTh78M5ep/FORnafNDX5DYzNPnadLSJzpQtk0V2itDhRcB3n0W?= =?iso-8859-1?Q?nPvniaKoGoxr85ZT7+EDXy15kVfXr0o/nDV0FrMkwbCL+XPg5aswNreElr?= =?iso-8859-1?Q?Y6IiKidWb/4+GSXOtxPKpxzlIGiaF8MUDvIkQyujAsTWWWIWqu0Lu7A+f+?= =?iso-8859-1?Q?xXhzDc9y0hNjkxRLyed+VPLRCR7zTS9ODv5EWRCOTlz2CzXcVLpQ/jKAPs?= =?iso-8859-1?Q?uJXMlg49heHpTzfu/mmtFO6Xr79HwAjc5AugyW/JHYAEUEbpGcr96pZc18?= =?iso-8859-1?Q?oOP3agZEBFASnZVlQcopmAzIdM/2zG3YkWJlZG6AQog1CUXF5Q9E8qKnks?= =?iso-8859-1?Q?EpO4J+ZXNW3simt+0cs3YU9Ao9z5kOwPaRKDl6W0QlWCYSvq88IWb1Y963?= =?iso-8859-1?Q?N4w5j8iRSvztSgdcpnUpN7nFRnCpX5RBHCr5V3NIWzeL2VW001e2Ucfrg6?= =?iso-8859-1?Q?+WB8VU6cYA0nyHd76q4kxn527+KxcaL+22bWS8GXfA4yy0TFlq0gVoX49S?= =?iso-8859-1?Q?Y1fOZk9MmHHHjSQJoahyefcvIelENafRm/NdjKhyib4K/Q9FOT1crtVh49?= =?iso-8859-1?Q?+xp9Po0Mk+ii0cBicshnBWA5usLPgt6u0VhsD/oEhreGW6yNo/zJ6MVPBd?= =?iso-8859-1?Q?lVeJ5Q7SlCY8T+8zUnLsT7KWClebB+2z+jiChs6o7W3YAazwWR+EJ/41xD?= =?iso-8859-1?Q?LGtmOnsqtCWfDFqCRnwnmiNL8C35VeoMtmoNP6lyyHvlXpeMDxCSTpmK6X?= =?iso-8859-1?Q?8lJWJG1OkKCBL07rrvkSMtHc/qaJdNFJH1FySR5OLoTZv8attPbd8x9iw6?= =?iso-8859-1?Q?QryHgRlECkEwNvp2bE4+BSobBMURBY/iomX6p2oEvB/yVvCHTmieE1KDpk?= =?iso-8859-1?Q?XdDsLyAxceR+j6N+aX+V13Q8iXCYVecpQj7PqTu875rbe7HC3wG62qJ4MG?= =?iso-8859-1?Q?L3lv7LO6+mtv01fnIi0cJaDGInrsaF1fxH?= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS4PR01MB10249.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: fd8ae220-3320-4f28-3c14-08dd1459ef06 X-MS-Exchange-CrossTenant-originalarrivaltime: 04 Dec 2024 11:51:05.1034 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 1faf88fe-a998-4c5b-93c9-210a11d9a5c2 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: oB1O99EkacZSat/caKZO/uE0V8CgH+OfSF9i+H330eNIdeSbtTASbzf5E+dx9jbk2YBFDfmEsq7fN/++mkOamw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM9PR01MB8184 Received-SPF: pass client-ip=2a01:111:f403:260c::71d; envelope-from=e.fraga@ucl.ac.uk; helo=EUR03-VI1-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Spam-Score: -6.27 X-Spam-Score: -6.27 X-Migadu-Queue-Id: 4C0BE6D01 X-Migadu-Scanner: mx12.migadu.com X-TUID: 44YAybDeakZC Response below/inline for email Michael Heerdegen wrote: > (original email sent 4 Dec 2024 at 11:50) >=20 > But the real problem is that the org table export mechanism thinks that > the time field doesn't look like a numerical field, so it wraps every > such field in quotes, and the exported data file will look like > > | 2024-09-18 "11:40 CEST" > | 2024-09-19 "11:27 CEST" Is it possible to specify a format to timecolumn that includes both the quotes and the time zone? I'm thinking something along the lines of ... timecolumn(2, "\"%H:%M %Z\"") (untested) --=20 : Eric S Fraga, with org 9.7.15-a1df10 in Emacs 31.0.50=