From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id QFJ1NMomc2JvlQAAbAwnHQ (envelope-from ) for ; Thu, 05 May 2022 03:22:18 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id CM1vM8omc2I6fgEAG6o9tA (envelope-from ) for ; Thu, 05 May 2022 03:22:18 +0200 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 84100397F6 for ; Thu, 5 May 2022 03:22:18 +0200 (CEST) Received: from localhost ([::1]:42306 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nmQC9-00017G-Np for larch@yhetil.org; Wed, 04 May 2022 21:22:17 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:43366) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nmQBi-00016t-VD for emacs-orgmode@gnu.org; Wed, 04 May 2022 21:21:50 -0400 Received: from ciao.gmane.io ([116.202.254.214]:41282) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nmQBh-0000NY-KU for emacs-orgmode@gnu.org; Wed, 04 May 2022 21:21:50 -0400 Received: from list by ciao.gmane.io with local (Exim 4.92) (envelope-from ) id 1nmQBg-0009at-7o for emacs-orgmode@gnu.org; Thu, 05 May 2022 03:21:48 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: emacs-orgmode@gnu.org From: TRS-80 Subject: Re: from table to properties the inverse columview operation Date: Wed, 04 May 2022 21:21:38 -0400 Message-ID: <87levg22ql.fsf@isnotmyreal.name> References: <871qzf7x27.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) Cancel-Lock: sha1:CBSBwWiNAPvrq0mPVj0PppWJvn8= Received-SPF: pass client-ip=116.202.254.214; envelope-from=geo-emacs-orgmode@m.gmane-mx.org; helo=ciao.gmane.io X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.249, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=no 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" X-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1651713738; 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: content-transfer-encoding:content-transfer-encoding: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post; bh=0+txtKx2Dz6JftLzC+dx2Z1nl9xeKfKnNNVRNbBicDU=; b=JT+96o6bD1xw4Dji2JdTExlLtskh5NCuQqmiUwIDs4+BPUPVwhvGfRM0xa/Fd6jdnMO97q ThkOO3k3alcEaFl31UMQSeKte8RZjcapl0wT973EJ8ZH9vkd5ECqVPvNOrAcriWAxhm05u maBWn4AnL+W9s4rjafO+BiP7cd7v47EcENA9wOMVUZn7c5nH/hYYABVku7DOTvHTMqt+RD nir3a/eLv+Y+pYMSB8QC9CjiI1ZkWPFQPtWvRYRL4u16EpcU7EX77bOn5YGLrxGPUyjmbP R8Lm7DRlb3H5UIBmL4V0nI0kHI3y8hgc+x9XpJTe9bELS3wYnyRiON4WXIrMsA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1651713738; a=rsa-sha256; cv=none; b=ovO/mYOFFREDl9zT3ixnYNyNe6MeDiRpZE4xLsUE0l0aPpjwpkPENanNd1szs4tQtK0u7P NzsQ7/qVN0MHw7e6EqiAhP414lFoeiDtP5FewLQbOOze1bwQZLMr3OZpjbaE9z8Ese1Zfw N01cpzEu2V9Fi6OHLf/JJGBPWBsJrxivpbY5HSRm41H+VYr3kg4p/wJ2/UU6S9Ivn1yrkJ 4Z8564bzeO/6DExghLgUwJtK/m2JaYNBz6O1/Fqy0MZv1ZU89lgI/b2tEkr0HKzhjejlyO khcZlHPGIZamEk1Qa4OJvMZuXENQrFAqGRjvXIK7e4D1CCaZx+bTCELqGQKVSQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=none; 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" X-Migadu-Spam-Score: -2.29 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; 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" X-Migadu-Queue-Id: 84100397F6 X-Spam-Score: -2.29 X-Migadu-Scanner: scn1.migadu.com X-TUID: JtBZf4hGmo5g Uwe Brauer writes: > Hi > > I have for example > > * Grupos :noexport: > :PROPERTIES: > :EXPORT_OPTIONS: num:t > :COLUMNS: %10GRP(Grupos) %10HOJA(Hoja Nr) %10EJ(Ejericio Nr) %17DATE(Date) %7STATUS(Status){X/} > :ID: Grupos > :END: > > ** WAIT 1 <2022-02-03 jue 16:30> :Annu22: User > :PROPERTIES: > :ID: 6c53abda-5351-4651-8ec0-60138b248baa > :Email: user@gmail.com > :Grp: Gr1 > :Usuario1: User1 > :Email1: user1@gmail.com > :Usuario2: User2 > :Email2: user2@gmail.com > :StEnv1: [X] > :H1: 9 > :P1: 5 > :End: > > ** <2022-03-06 dom 18:16> : Ejercicios elegidos de la Hoja1: quien puede hablar el día <2022-03-07 lun> > > #+TBLNAME: hoja1 > #+BEGIN: columnview :maxlevel 2 :skip-empty-rows t :indent nil :hlines 1 :format "%5TODO(Status) %5Grp(Grupo) %5Usuario1(Miembro1) %5H1(Ejercicio elegido) %5P1(Porcentaje) %7StEnv1(Solución enviado){X/}" > > | Status | Grupo | Miembro1 | Ejercicio elegido | Porcentaje | Solución enviado | > |--------+-------+----------+-------------------+------------+------------------| > | | | | | | [1/1] | > | WAIT | Gr1 | User1 | 9 | 5 | [X] | > #+END > > So a table is generated based on earlier entries. > > Is there the inverse operation? Given a table I recover the original > properties? I think it might be easier to do in awk than ELisp. And I am better in Elisp than awk, but awk was made for almost exactly this sort of thing. Anyway, if some existing (Elisp) function exists for this, I would like to know about it as well[0]. Cheers, TRS-80 [0] I have already re-implemented too many things which already existed, that I just did not know about at the time! :D