I need someone having a software to extract the following fields from the PubMed Database into an Excel Sheet:
- First author First name
- First author Last name
- Email address
- Article name
The program should check if the last name of the first author is present in the Email address. If not, additionally the Last authors details (first name/ last name/ Email address) are also required. The program must also tolerate files with thousands of records since only about 25% of the database entries have Emails.
I would send keyword lists for different PubMed searches where then the aforementioned Email extraction should take place.
Initially we would start with a pilot extraction from one keyword list. After evaluating the results follow-up orders will be placed.