Tip #14: Testing for Key Article Inclusion in Web of Science

By

In previous posts, we showed you how to test your searches for inclusion of key articles in PubMed and in Ovid databases. You can recycle your PMID strings to create test sets for other databases, too! I search Web of Science for virtually every SR or scoping review I do, so I usually recycle my list of PMIDs. Here's the syntax:

PMID=(12450163 or 15982428 or 27391569 or 27940902 or 28941542 or 29056764 or 31651628 or 31874458 or 32340564 or 32855234)

While this list contains 10 PMIDs, only 6 of them are indexed in Web of Science. I need to keep track of how many records the string retrieves in Web of Science the same way I would in MEDLINE.

For non-MEDLINE articles, you can use DOIs with the following syntax:
DO=(10.1182/blood-2020-143231 OR 10.1093/jac/dkaa016 OR 10.1016/j.jadohealth.2019.11.163 OR 10.1089/trgh.2018.0061 OR 10.1093/ofid/ofz360.2167 OR 10.1016/j.apmr.2019.10.050 OR 10.1177/0333102419859835 OR 10.1111/head.13549 OR 10.1212/CPJ.0000000000000401 OR 10.1080/01658107.2017.1316744 OR 10.1164/ajrccmconference.2017.C44 OR 10.1371/journal.pone.0157324 OR 10.1097/NRL.0000000000000074 OR 10.7448/IAS.19.8.21487 OR 10.1016/j.pmedr.2015.09.011 OR 10.1177/0333102415581304)

There's more than one way to get a list of DOIs. Because I already have a list of PMIDs from my MEDLINE test set, I harvest them from non-MEDLINE records indexed in Embase. In the following example, I am exporting a spreadsheet with selected fields (including DOI) from 21 non-MEDLINE Embase records: 
export the DOI for a list of Embase records to a spreadsheet




















Then I can sort the DOIs, copy/paste the DOI column into a Word or a text editor, and use find and replace to remove the URL prefixes, insert ORs, remove line breaks, and whatever other text processing I have to do to get it into the format I need for WOS:
Copy/paste the DOI column in the spreadsheet to create your test set

Comments

Post a Comment

Popular posts from this blog

Tip #1: Bulk export from Google Scholar

By
Image
This post was updated on October 10, 2022 with new instructions for #3 under "For EndNote users..." For years, I kept hearing from colleagues that I should be searching Google Scholar as part of my systematic review projects. I didn't, for 3 reasons: I didn't know GS' search syntax GS notoriously does not allow bulk export to reference managers I didn't have a sense of how many results I should export.   Last fall, I finally said enough was enough and it was time to learn how to wrangle this beast. It turns out that there is now a third-party tool that facilitates bulk export from Google Scholar, Harzing's Publish or Perish . Here's how you get started: Download PoP for free Paste your query into the Keywords field Set your maximum number of results. I follow the guidelines on p. 135 of Wichor Bramer's dissertation , which is a great handbook for expert searching. Bramer suggests the first 200 results, or 100 if you are getting low numbers of res
Read more

Tip #46: Exporting Records from Clinicaltrials.gov into EndNote

By
Image
Many thanks to Ben Harnke, MLIS from the Strauss Health Sciences Library, University of Colorado (ben.harnke@cuanschutz.edu) for this week's tip!   Overview The following are instructions to export records from clincicaltrials.gov (Trials) to EndNote, with the ultimate goal of sending the records to a screening software, namely Covidence. The new Trials website ( https://www.clinicaltrials.gov /) will only export in JSON (Java Script format) and Comma Separated Values (CSV) formats. We will be using the CSV export format, the format for spreadsheets. These instructions are simply slight modifications to the Clarivate instructions for importing tab-delimited files (spreadsheets) into EndNote. Before proceeding with the following instructions, first decide whether it is necessary to export directly from clinicaltrials.gov to begin with. Cochrane CENTRAL contains records from Trials and is more user friendly. CENTRAL is limited to "randomized and quasi-randomized controlled tri
Read more

Favorite Features & Sneaky Solutions: A Database Tips Lightning Round: View the recording!

By
On October 7, 2024, the Medical Library Association's User Experience (UX) Caucus held a database tips lightning round. Watch the entire event recording! MLA UX Caucus Database Tips Lightning Round * (October 2024)  View presenter slide decks, the full chat transcript, and a summary of Q&A and tips culled from the chat: Lightning Round documents  (October 2024) The presenters and their topics, with timestamps of when they appear in the video, were: Methodology and Publication Type Filters in EBSCOhost Databases (00:40) Marilia Antunez, MA (LIS), MA,  Life & Allied Health Sciences Librarian, Associate Professor, The University of Akron (OH) Tricky Truncation in ProQuest Databases (07:15) Jocelyn Boice, Associate Professor / Collection Strategies and Data Analysis Librarian, Colorado State University Libraries Embase Query Translator (12:52) Molly Higgins, Systematic Review Librarian, USDA NESR What’s Included in Emtree’s /syn and /br (19:20) Amy Nadell, MSLIS, MA , AHIP-D, L
Read more