From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2.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 YARUKQI0UGcSKwAAe85BDQ:P1 (envelope-from ) for ; Wed, 04 Dec 2024 10:50:42 +0000 Received: from aspmx1.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2.migadu.com with LMTPS id YARUKQI0UGcSKwAAe85BDQ (envelope-from ) for ; Wed, 04 Dec 2024 11:50:42 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=web.de header.s=s29768273 header.b=tjTOAws5; dmarc=pass (policy=quarantine) header.from=web.de; 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-Seal: i=1; s=key1; d=yhetil.org; t=1733309442; a=rsa-sha256; cv=none; b=fyeQbSkySrQ8qPWdodr4U4qYu6xSWd36/9YG1AjlLyO/5+NPZm+lkAefUIDahLzMUDtVxd r/3XwaRnupa9ATYYw+tCTFdki5VJe2X5waSqqrJBOLNkRHNuv7ruYiNSzKQHd/i4PKk7Gw NX5YlvglG0NsYDqe0K7yaY17R7hHhssgKG6WycYUtBUjVA63u8DU0HkHuk48f9bIP3GTXt h+DT1WACTuOb1G/kXxwLDxj4vDayf4UauYHv7eM9qnUPeDFB8YspSZVGhuTMFu1U5x+6PY xZkE5N33dpoR2ZaZHIeGxHtk20wWJ4KbDuUbVjv+rRwfA3P6dM5znBEx2lxHKQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=web.de header.s=s29768273 header.b=tjTOAws5; dmarc=pass (policy=quarantine) header.from=web.de; 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-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1733309442; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=b7lyZ8u3IxNP3/2LOqVyhv8UB9LKzv/DKRTH4qBh3W0=; b=hLSzgSFE3ZYz+YMK3gm64K30DhlO1Voe0EDtSFwy4XBJq5ccUtIdLKhsEARGpLstgTJjsW 3VpqzyEigaife062/xr6TyFGlC2uYEgzEes255u3ua+B3ZgoFBS2tAJ6wdE/pJlnesz7od ievwtBTySwHYhiW/0MhEdvwp7UUlvhK/03gZy7o80mv2cFa3evAA5XHvNr1GK5MjZ3ORez lsIv6+fsI4lmogTaJytoAZNb32kTrXgRLSsrOReyYS56zOBhze2dVWsju/sBjmo0v54y01 u8qluUwq9sUDqGhctUiYhXO4wJea1E8nx6zABMnBp9pcuVHQtK4eo29dlCJ9LA== 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 442DC1CBD for ; Wed, 04 Dec 2024 11:50:42 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1tImwz-0003uY-5O; Wed, 04 Dec 2024 05:49:45 -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 1tImww-0003uL-Ng for emacs-orgmode@gnu.org; Wed, 04 Dec 2024 05:49:42 -0500 Received: from mout.web.de ([212.227.17.11]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tImwt-0005ay-HQ for emacs-orgmode@gnu.org; Wed, 04 Dec 2024 05:49:42 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=web.de; s=s29768273; t=1733309377; x=1733914177; i=michael_heerdegen@web.de; bh=b7lyZ8u3IxNP3/2LOqVyhv8UB9LKzv/DKRTH4qBh3W0=; h=X-UI-Sender-Class:From:To:Subject:In-Reply-To:References:Date: Message-ID:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=tjTOAws5n4hxQ/uZeD+gd1uYjsQ8EAGiGFnlbju+Y61Cward9kZMV+4dMDefjeHw j7yG/jTAc6xxLMcHdtrXwPWhBotamRKxYzIQh2jIPMw4O+V5sP1rs+YkMZz16CUnv /5UoRGA+I1yhAXwn/FxvqPcQUG7HlsXsbkirX9ZGkPRPlfk3MXRI41QwgBdJqVJqd 0L3N3TorkWyr3fC6sc6wgBrPKpoEHNshGYK0hzp34w1LMUgPoevuBp24jwwxt6/Yg twGN+HEre735Kcdoe5yX/AZbb5Aqo9/s4zVqU/LHBOV8yg8gNCOavxkpkkfI2pYIS 2cBCRqBsxBNbAv7UQQ== X-UI-Sender-Class: 814a7b36-bfc1-4dae-8640-3722d8ec6cd6 Received: from drachen.dragon ([92.75.138.197]) by smtp.web.de (mrweb105 [213.165.67.124]) with ESMTPSA (Nemesis) id 1MY5fb-1t9C2811AL-00YHzj; Wed, 04 Dec 2024 11:49:37 +0100 From: Michael Heerdegen To: Org Mode List Subject: Re: Plotting a table of date+time pairs In-Reply-To: <87iks2qnr1.fsf@ucl.ac.uk> (Eric Fraga's message of "Mon, 2 Dec 2024 12:21:22 +0000") 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> Date: Wed, 04 Dec 2024 11:50:40 +0100 Message-ID: <87ser3pvr3.fsf@web.de> User-Agent: Gnus/5.13 (Gnus v5.13) MIME-Version: 1.0 Content-Type: text/plain X-Provags-ID: V03:K1:64kMvE1HkvDC7X9N9PND4JnF+fSAFbNYDPLkKztpx4WxvfC+gI+ EOmpcpeSjv306QQNFXo8Lty9qoz4FL7UQXSCIFiuzUgdhBRlIp+GDhEavCtcCWz0dSglByC K8zDuR37Wmk27n7YLFQWjx9plWLfe6nYBc22qwxj9ee7d8Q5jFsVi0t5Y5ill6Tm+I9g5OO nlJQgz0WnjFKtScvyDwdQ== UI-OutboundReport: notjunk:1;M01:P0:CCsIk6u+ZdQ=;ByVXM2sokgjE0n5r1g+YOTEOzjr EVwwE3M7us2pNQSvrdZ22/kJl1p6qzveu0ot2gvJEEdUm9gPNp344CqkjbYjqR2UFednaaOXo sgnO3Qzx0EOffHuS5Bhc2zpLGX4xNuSmyXpYAqyEnrpgIXqmStE8idS7SzC0YoXXSaQeTXx8b 3Zi3BIcPXsuJtuCnTxLCSy8Nil+WhwbsAGiT7/qAV8wpPyd2LnXbHVK9KNUTv6Tw3TJc6PocM g60nnVcH8kOb2MtTLHhzv5or0jBmWyfASP2W1OsEYH68tvF2PrZp+3ra6mPIdGLmbLODDRA5X cvSuSfilBKupwmB2piLbyJg3ju5JkyyUESEmEptcaOBrqxNYDZ3LvZ7nTSqNTr0KApFi2lFig eVSLPmNpMn8JVcM29jkdt6zGK8EIYQR3hk6eeijTPw4m5SJ8at6My821tGIdFIb27eMvJAo9j sfI4bJVVghTvswcq9XO8xdRGAS3CIwUhsAfHMHEkjNuDTutwz30cZI+XGQPYKAlQJhHJMhdOM lDwNwXeXPdBIp5BNWuLjTObwsXrEscbkdom65Ozl2/7+fIE5OmARYqbsrN16YUIoFGv3XuSIj stt3rtb7d3cyEYxZtKw7bKzHiWnsxB9+p6QKuuOnm66EfdjW90z5lIxwmWz1W0bGMAgD3lSwS TvSEcst+QSWpAYZCQEKDGYaWOnMEovowEC4WPtqAoboz05nCZxAYLbBpDQUH2PgDZ/dS8PWZf hw/uuLl0k6O6k902ET+Kt+u/lPllwvHYPCChkD+vrr59lmrBljv6BFg9cLzpSJX3w5yrx4KFl embZ/Vc1BXpEp/5wQ5xpeZEF88yMMjrvkBTql9Kx9r331akPDK2kLuCSHgOfqXbGNivVLyvsi lz5SW5hWp3kYtE+rlItDDHAI1FsCf/s9ZbBeEFfwCM+HP2wlmy0RqFXOitY05NosCXJAb4A14 kI/VsHItyd8XQDdzejNwXY6yLIiGqc1sLHrqaaCN2iiS3VgpQR+KvVl73n9FC8VDoc+wTvSjI 45Xwv0s+6lPnS7DTWwvrZhkwgM6GwL4qffYfN5UNT5/rfVckGzrJiFRRaFKyiY0TkX2UwSU7x Ulcl/lgwA= Received-SPF: pass client-ip=212.227.17.11; envelope-from=michael_heerdegen@web.de; helo=mout.web.de 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, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, RCVD_IN_VALIDITY_CERTIFIED_BLOCKED=0.001, RCVD_IN_VALIDITY_RPBL_BLOCKED=0.001, SPF_HELO_NONE=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: -1.88 X-Spam-Score: -1.88 X-Migadu-Queue-Id: 442DC1CBD X-Migadu-Scanner: mx12.migadu.com X-TUID: kO8bLBIuXcY3 "Fraga, Eric" writes: > > I now have one remaining problem: my time values in the second column > > contain the name of the time zone - the purpose is to flag the time as > > summer or winter time. Currently I need to remove these indicators from > > the table, else plotting fail, gnuplot doesn't understand the data. > > You can specify the format of dates/times in gnuplot and then manipulate > them. See "time/date specifiers" in the gnuplot info manual and also > read about the strptime() function. I don't have any examples of these > at hand unfortunately. Yes thanks - but I really think Org gets it wrong. Look: With | plot data using 1:(timecolumn(2,"%H:%M") ... gnuplot happily accepts a data file looking like | 2024-09-18 11:40 CEST | 2024-09-19 11:27 CEST | ... ... It just discards the timezone which is good enough. No problem with the kind of data for gnuplot (AFAIR I read in the gnuplot manual that time zones are not supported ad-hoc - anyway, I don't need this for plotting.) 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" | ... ... instead. Then gnuplot doesn't find data matching "%H:%M in the second column of the data file and interprets it as zero or 00:00am or whatever. Can I make gnuplot disregard the quotation marks? Else I must tell org that these fields should not be quoted. But ironically the only way I know to do this is again a hack: I must adjust `org-table-number-regexp' which... sounds like a good solution but since org disregards a file local binding I must change the global binding of the variable! Ugh. Better solutions welcome. Thanks, Michael.