I think code like this would also work: #+BEGIN_SRC emacs-lisp (let* ((url " https://mail.google.com/mail?view=cm&fs=1&to=duncan...@indeedemail.com";) (struct (url-generic-parse-url url)) (filename (url-filename struct)))
(cadr (assoc "to" (url-parse-query-string filename)))) #+END_SRC John ----------------------------------- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu On Mon, Nov 30, 2020 at 7:51 AM Ian Garmaise <ia...@phorixsol.com> wrote: > 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" | "ciarax...@gmail.com" > | > | "Duncan" | "duncanx...@indeedemail.com" > | > > Thanks a million! > > Ian > > > On Sun, Nov 29, 2020 at 10:39 PM Kyle Meyer <k...@kyleam.com> 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" | "ciara...@gmail.com" | >> | "Duncan" | "duncan...@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 > ia...@phorixsol.com > Toronto cell: 416.432.2251 > NYC: 917.512.9535 > > https://www.linkedin.com/in/igarmaise/ > > http://www.PhorixSol.com >
