 |
|
List Archives > 
Reference Manager List Archive > 
Archive by date > 
This Month By Date > 
This Month By Topic
1 XML Imports 2 Extracting e-mail addresses 3
| 1 XML Imports 2 Extracting e-mail addresses 3 |
|
Author: Kim Wyman
Posted: Fri, 14 Jul 2006 18:32:24 -0400
|
Macros / Scripting
Date: Fri, 14 Jul 2006 16:05:00 -0800
Sender: "listmaster"
Precedence: bulk
Reply-To: "ris-list"
Dear ref-list
1. Having just upgraded to RefMan 11, I'm keen to use the XML import
/ export options, however a Medline search results file in XML, emailed
to self from http://www.ncbi.nlm.nih.gov/entrez/login.fcgi won't load,
either when saved as a .txt file or HTML file.
2. The second issue I'd like to solve is automatically to extract
each contact email address into RefMan's User Def 1 field or similar.
(When supplied, lead author's email is added to the present Address
fields in most databases). Has anyone developed a solution for
extracting emails into a separate field ? ?
I actually have a solution for individual filter files (ie not XML) but
its long-winded. It involves first loading the downloaded .txt file
into a Microsoft Word file, then running a VB macro which places a tilde
(the ~ mark) in front of every string with an ampersand (the @ mark).
For some reason my solution only works 50% of the time, other times it
gets into an endless loop and crashes. When it works, The Word file is
then saved as a .txt. Any Import filter files must then be adapted
manually through the Import Filter Editor for the destination field
<Source> to split any information at the tilde (if there is one),
loading post-tilde into User Def 1.
3. Finally a general question. Is there a macro or scripting
language facility anywhere in RefMan ? If not, any plan for either ?
Any advice will be appreciated
Kim Wyman
Director
------------------------------------------------------------------------
--------
"kimw"
tel: +61 (0)3 9457 4253
fax: 9457 4243
mobile: +61 (0)438 365 001
Kim Wyman and Associates
Medical Research Redevelopment Institute
PO Box 2017
IVANHOE EAST 3079 Australia
------------------------------------------------------------------------
--------
|
Previous by date: Re: Clear marks -> records are only marked on, Robert Palermo
Next by date: Re: Clear marks -> records are only marked on, Sarah Cage
Previous thread: Advantages & disadvantages of version 11 - feedback, David R Price
Next thread: Clear marks -> records are only marked on retrieved, Peter Malling
|
|
|