From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 8CcBDyi1rWGU/QAAgWs5BA (envelope-from ) for ; Mon, 06 Dec 2021 08:00:56 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id kO+nCii1rWFLUwAAbx9fmQ (envelope-from ) for ; Mon, 06 Dec 2021 07:00:56 +0000 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 704BB8B24 for ; Mon, 6 Dec 2021 08:00:55 +0100 (CET) Received: from localhost ([::1]:41988 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mu7zZ-0005ov-J9 for larch@yhetil.org; Mon, 06 Dec 2021 02:00:53 -0500 Received: from eggs.gnu.org ([209.51.188.92]:53264) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mu7yu-0005om-MD for emacs-orgmode@gnu.org; Mon, 06 Dec 2021 02:00:12 -0500 Received: from relay-egress-host.us-east-2.a.mail.umich.edu ([18.219.209.13]:45362 helo=resilient-gofannon.relay-egress.a.mail.umich.edu) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mu7ys-00087V-UN for emacs-orgmode@gnu.org; Mon, 06 Dec 2021 02:00:12 -0500 Received: from healthy-ceasg.authn-relay.a.mail.umich.edu (ip-10-0-73-101.us-east-2.compute.internal [10.0.73.101]) by resilient-gofannon.relay-egress.a.mail.umich.edu with ESMTPS id 61ADB4F3.B521E.33FF4B8C.382053; Mon, 06 Dec 2021 02:00:03 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=umich.edu; s=relay-2018-08-29; t=1638774003; bh=VB9sQqUQIxgc50UFIudD+ga0dcqY7Hz6VDgs2ODzNXc=; h=To:cc:From:Subject:In-reply-to:References:Date; b=KK7LntDC9/AlAQuMYIpCla2fjFCu42wZgY+E50Pd1KPBc7apW9jr9zBRFFuswKCxj ELc+zSAhBp69Pvp3Vu6J+Ns+/2aJLrLDD6E49Ndh4SF5Jr5F+hHBF0d+1Y6UJD9+dd Hbi8mdmf10nHyyPC5buP12/X3LGBMHxu7gAvBcGdL3BsimVDqThghx2fLMVoyk+kqk FVm4dn3eIKnAtmwGOLm0dTTU2kIiIxY6SWuhPZs7kcqdz8+ZRKK3aBWqkLPio47jJ3 Ad9Ue2gkis0E7AQe/xsRacSqci7/m0ft0C/WZUzOrV69B+oyd+x8wTwuXGIxg7sJrz rs6bJEPNFSx6w== Received: from localhost (Mismatch [88.254.21.189]) by healthy-ceasg.authn-relay.a.mail.umich.edu with ESMTPSA id 61ADB4F2.18A0B.346A77A1.50364; Mon, 06 Dec 2021 02:00:02 -0500 To: Tim Cross From: Greg Minshall Subject: Re: quotation marks in table cell vs. org-babel-ref-resolve In-reply-to: <87a6hgujob.fsf@gmail.com> References: <4033335.1638552531@apollo2.minshall.org> <4040418.1638556010@apollo2.minshall.org> <87mtlhgsee.fsf@gmail.com> <4107465.1638587764@apollo2.minshall.org> <87a6hgujob.fsf@gmail.com> Comments: In-reply-to Tim Cross message dated "Sun, 05 Dec 2021 08:34:16 +1100." X-Mailer: MH-E 8.6+git; nmh 1.7.1; GNU Emacs 27.2 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <765014.1638813724.1@apollo2.minshall.org> Date: Mon, 06 Dec 2021 21:02:04 +0300 Message-ID: <765015.1638813724@apollo2.minshall.org> Received-SPF: pass client-ip=18.219.209.13; envelope-from=minshall@umich.edu; helo=resilient-gofannon.relay-egress.a.mail.umich.edu X-Spam_score_int: -1 X-Spam_score: -0.2 X-Spam_bar: / X-Spam_report: (-0.2 / 5.0 requ) BAYES_00=-1.9, DATE_IN_FUTURE_06_12=1.947, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, 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: , Cc: emacs-orgmode@gnu.org Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1638774056; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=VB9sQqUQIxgc50UFIudD+ga0dcqY7Hz6VDgs2ODzNXc=; b=Yzutlm827SbS9L0xwmLqR1hPIX3s+wR9K+rKNqMi7Ls3SU7pE/L7z0Pztim4i6wbv0v2t2 x78auQ/h+lqnVQ+1yUesTGS2fn0rB1nzNAUgljmVk8J3udh1qmIYcP3QvPEy2mZqDHuPzd EL96HFfHblgtEiptkCpb0FGex6u9VLvRzRIS8iBJinAM+HV+cGe9Hu3nYRxweRz/5nXKIC wTHEDDx8FxW52j64NbdTANteHbGLcFAXbUJm1OvX+E+TtBdiwgUjdLc/xezRt4dY/ypJOi 5btAz91KwnTmYVGEt74BYbOII+t5Z5mbzEKHAmQc6fZiEBAC8K54yuN4PWWYgw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1638774056; a=rsa-sha256; cv=none; b=PvZ0Y0Am5sABnDK8styjjFVAyAc8bRuvE6JOn/8yZKtB/KVA0fXfyOyeP78w612zoXrbnp 5zcWzUnPhki5HGg4bTOdPuZm0sSP1VHujcQABL5X+qIwfyb/IDjvJ8o9nyAT9eL4DZdjBs dtyHLtgWBCoRr+1ULHN9RQjmNX9qzR/A+qKJ1V4ixqCYd1VLMcekSMLZkYdLyPUcXTiBxy atfYpRowJbEaa+GRVcc2/tK0O9+VdvawyD8/tsr40Fuxq32Hld8+4mlzhrfMbr/X5AFtY7 5lQLC5tSoOf/dHwygd/5lMkFprlI0DPfwlc1R7Wj78PEbNYfvuYwqaBmTZX4cA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=umich.edu header.s=relay-2018-08-29 header.b=KK7LntDC; dmarc=pass (policy=none) header.from=umich.edu; 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: -1.14 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=umich.edu header.s=relay-2018-08-29 header.b=KK7LntDC; dmarc=pass (policy=none) header.from=umich.edu; 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: 704BB8B24 X-Spam-Score: -1.14 X-Migadu-Scanner: scn0.migadu.com X-TUID: kWL9LPC/XIEb hi, Tim, thanks for the reply. > I don't know. It could be related to the spreadsheet capabilities or it > could simply be an oversight in how the code extracts values from > tables. if anyone has any knowledge in this area, i'd be curious to hear. > I tend to use the function org-table-to-list to extract the data from a > table. It gives me a nested list which I can then process with elisp in > any way I want. I don't know if that would help or how it will interpret > a cell whic contains both quoted and unquoted data. for the record, things -- lists and lisps -- being equal, the function you presumably meant to write was =org-table-to-lisp=. =org-babel-ref-resolve= is convenient to use (as you provide a REF, rather than create a [temp] buffer, visit the file, whatever). but, it isn't clear to me what functions (=org-babel-ref-resolve= and/or =org-table-to-lisp=) should be considered part of the "Emacs Org Mode API". :) (i've gotten "around" the issue by prepending my e-mail addresses with [: SPACE].) cheers, Greg