From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 6HE/KqtWxF/EZQAA0tVLHw (envelope-from ) for ; Mon, 30 Nov 2020 02:19:23 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id GJj8JatWxF/3RAAAbx9fmQ (envelope-from ) for ; Mon, 30 Nov 2020 02:19:23 +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 DF83194038E for ; Mon, 30 Nov 2020 02:19:22 +0000 (UTC) Received: from localhost ([::1]:37826 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kjYme-0006Nv-Bs for larch@yhetil.org; Sun, 29 Nov 2020 21:19:20 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:33362) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kjYm1-0006MT-Ea for emacs-orgmode@gnu.org; Sun, 29 Nov 2020 21:18:41 -0500 Received: from mail-qt1-x833.google.com ([2607:f8b0:4864:20::833]:46274) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kjYlz-0007Be-8G for emacs-orgmode@gnu.org; Sun, 29 Nov 2020 21:18:40 -0500 Received: by mail-qt1-x833.google.com with SMTP id f15so7186342qto.13 for ; Sun, 29 Nov 2020 18:18:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=phorixsol.com; s=google; h=mime-version:from:date:message-id:subject:to; bh=/rNrsbMyWbeZs6UcFcGk0LcaUB3CzdAknPw1Zb2oNi0=; b=JywzuwXVTZBgCs9q6grB4r6FnY4lCRRdw0Ri708NkBB/MB14vf689oyDtEwgmW7Pnn DGWs9/woh613/vWkn9JV1U8CelB+RYuYcDPd+SwEWyYgpbRDTE1pjC/3l2YSnp4aDDnX 4uoied37C3sPmKree/BNqb1sGLSfDsfIFw/QQ= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=/rNrsbMyWbeZs6UcFcGk0LcaUB3CzdAknPw1Zb2oNi0=; b=lxH/nV4VndDCT2wu976A0DA5dDo8uAeblN/cIrZ0JFyndRkjqLf2ip8p4XFuZ0Qy2I COznDOvps609MLXSX4NwBm3rJwlOUfmBpBXpYTAM4+tsw7ME9fVJOdhN+vOkP+yz5xRL EBbW0MAYN72nBTvdxSlN9bFmDkN39OV0W8i9xJWAycZUUEO4BlJMYvmsIUFHIeJWIICs fPhAXoDGGel7irKYTyztCmbso335osAs0bWOyHbRbBG1qQZDuUKVZI80z0lXcenyba49 pL9XmWGYRQXCDfuPJAv5fW5M5rXHzapzAqFY3zzaDEM6+AHefECfoCR0Jw3cgxa+U9Zt Xdhg== X-Gm-Message-State: AOAM530FqwdjrMmmKtsKI9cs8eGALwo55BI+cCTOWAVmuOa+AdY42t9Z CVFR7DVaY6dIyN1FOQKxO/U0qi6kU8b7FvA99nrZzXO3VgqE9iPQ X-Google-Smtp-Source: ABdhPJwwucTaLGLgt3hYBz/KxARZCE+8lSKslmTrDmmSL/fZTmgUTa0zNs1EIdaVTlvjD9m5WpMcmq+zbWE+CtZqUsY= X-Received: by 2002:aed:3865:: with SMTP id j92mr18963425qte.318.1606702716920; Sun, 29 Nov 2020 18:18:36 -0800 (PST) MIME-Version: 1.0 From: Ian Garmaise Date: Sun, 29 Nov 2020 21:18:25 -0500 Message-ID: Subject: difficulty extracting email address from property field containing gmail link To: emacs-orgmode Content-Type: multipart/alternative; boundary="000000000000b3b91805b549a011" Received-SPF: pass client-ip=2607:f8b0:4864:20::833; envelope-from=ian.g@phorixsol.com; helo=mail-qt1-x833.google.com X-Spam_score_int: -1 X-Spam_score: -0.2 X-Spam_bar: / X-Spam_report: (-0.2 / 5.0 requ) BAYES_20=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, 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.23 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-Spam-Score: -2.98 X-Scanner: ns3122888.ip-94-23-21.eu Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=phorixsol.com header.s=google header.b=JywzuwXV; dmarc=pass (policy=none) header.from=phorixsol.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-TUID: L1IQgzdtgyFH --000000000000b3b91805b549a011 Content-Type: text/plain; charset="UTF-8" I have created a kind of mini CRM using properties. Now I need to extract data from the entries to create a CSV file for use with an external email tool. I have used org-collector.el to extract tagged entries to a table, on which I then use orgtbl-to-csv to create the CSV file. This is working well, except for the property used for the email address. Unfortunately, I stored this as a gmail link. This makes it difficult to extract the actual email address using org-collector as follows: #+BEGIN: propview :cols ((car (s-split " " ITEM)) EMAIL_ADDRESS) :id "candidates" :match "testthis" :wrap example the result produced looks like this: | (car (s-split " " ITEM)) | EMAIL_ADDRESS | |--------------------------+---------------------------------------------------------------------------------| | "Ciara" | [[ https://mail.google.com/mail/?view=cm&fs=1&to=ciaraxyz@gmail\.com]] | | "Duncan" | [[ https://mail.google.com/mail/?view=cm&fs=1&to=duncanxyz@indeedemail\.com]] | I have looked at several methods that I found on the web to extract the email address from the link in the property, but haven't yet found a solution that I could get to work. Still building up my elisp skillset, would appreciate suggestions. -- ===== Ian Garmaise Consultant Phorix Solutions Group ian.g@phorixsol.com Toronto cell: 416.432.2251 NYC: 917.512.9535 https://www.linkedin.com/in/igarmaise/ http://www.PhorixSol.com --000000000000b3b91805b549a011 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have created a kind of mini CRM using properti= es.
Now I need to extract data from the entries to create a = CSV file for use with an external email tool.

I have used org-collector.el to extract tagged entries to a table, on= which I then use orgtbl-to-csv to create the=C2=A0CSV file.

This is working=C2=A0well, except for the property use= d for the email address.=C2=A0 Unfortunately, I stored this as a gmail link= .=C2=A0 This makes it difficult to extract the actual email address using o= rg-collector as follows:

#+BEGIN: propvi= ew :cols ((car (s-split " " ITEM)) =C2=A0EMAIL_ADDRESS) =C2=A0:id= "candidates" :match "testthis" :wrap example
=

the result produced looks like this:

| (car (s-split " " ITEM)) | EMAIL_ADD= RESS =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 |
|--------------------------+----------------------------= -----------------------------------------------------|
| "Ciara&quo= t; =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| [[https://mail.google.com/mail/?view=3Dcm&fs=3D1&to=3Dciar= axyz@gmail\.com]] =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
| &quo= t;Duncan" =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | [[= https://mail.google.com/mail/?view=3Dcm&fs=3D1&= amp;to=3Dduncanxyz@indeedemail\.com]] |

I have looked at several methods that I found on the web to extract= the email address from the link in the property, but haven't yet found= a solution that I could get to work.=C2=A0 Still building up my elisp skil= lset, would appreciate suggestions.


=

--
=3D=3D=3D=3D=3D
Ian Garmaise
Consultan= t
Phorix Solutions Group
ian.g@phorixsol.com
Toronto cell: 416.432.2251
NYC: = 917.512.9535

https://www.linkedin.com/in/igarmaise/

http://www.PhorixSol.com
--000000000000b3b91805b549a011--