Thanks Kyle, got it to work this way: #+BEGIN: propview :cols ((car (s-split " " ITEM)) (s-chop-prefix "gmail:" (my/extract-email-from-link EMAIL_ADDRESS))) :id "candidates" :match "testthis" :wrap example | (car (s-split " " ITEM)) | (s-chop-prefix "gmail:" (my/extract-email-from-link EMAIL_ADDRESS)) | |--------------------------+---------------------------------------------------------------------| | "Ciara" | "ciaraxxxx@gmail.com" | | "Duncan" | "duncanxxxx@indeedemail.com" | Thanks a million! Ian On Sun, Nov 29, 2020 at 10:39 PM Kyle Meyer wrote: > Ian Garmaise writes: > > > 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. > > I've never used org-collector, but quickly trying to wire up a function > to extract the email part of the text you show, I suspect some of the > trouble you're having is that the value comes in as a vector because > org-propview-collect processes it with org-babel-read. So perhaps > something like this would get you on the right track: > > (require 'subr-x) > > (defun my/extract-email-from-link (value) > (setq value (format "%S" value)) > (when-let ((link (and (string-match org-link-bracket-re value) > (org-link-unescape > (match-string-no-properties 1 value))))) > (thread-last > link > (replace-regexp-in-string > (rx string-start (one-or-more not-newline) "to=" > (group (one-or-more not-newline)) string-end) > "\\1") > (replace-regexp-in-string (rx "\\.") ".")))) > > > --8<---------------cut here---------------start------------->8--- > #+BEGIN: propview :cols ((car (s-split " " ITEM)) > (my/extract-email-from-link EMAIL_ADDRESS)) :id global > | (car (s-split " " ITEM)) | (my/extract-email-from-link EMAIL_ADDRESS) | > |--------------------------+--------------------------------------------| > | "Ciara" | "ciaraxyz@gmail.com" | > | "Duncan" | "duncanxyz@indeedemail.com" | > |--------------------------+--------------------------------------------| > | | | > #+END: > > * Ciara > :PROPERTIES: > :EMAIL_ADDRESS: [[ > https://mail.google.com/mail/?view=cm&fs=1&to=ciaraxyz@gmail\.com]] > :END: > > * Duncan > :PROPERTIES: > :EMAIL_ADDRESS: [[ > https://mail.google.com/mail/?view=cm&fs=1&to=duncanxyz@indeedemail\.com]] > :END: > --8<---------------cut here---------------end--------------->8--- > -- ===== 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