Tip #5: The Trouble with Curly Quotes

By
UPDATE: Thanks to Layal Hneiny for the screenshots and instructions for Word (Office on the Web)!
 
 Have you ever run into the "unsupported characters" error message in Ovid MEDLINE?
 
 
In more complex searches, it can be especially frustrating to pinpoint the exact character that isn't supported. This is a simple search example to highlight one common situation that will trigger this error message: Curly or Smart Quotes.
At first glance, both of these phrases appear to be the same:

“drug addiction”.ti,ab. OR "Substance Use Disorder".ti,ab.

But upon closer inspection you can see that the quotation marks are slightly different:

The drug phrase has curly or smart quotes around it and the substance phrase has straight quotes. 
 
Ovid MEDLINE does not support the use of curly or smart quotes. 
 
This is a simplified version of a search that hit my inbox last week. I was working with a faculty member in a shared Google doc. She had downloaded the shared document as a Word doc to send to another colleague. Between the rounds of edits, a random set of smart quotes appeared in a very long search string. The faculty member reached out to me stumped by the error message. I immediately knew what had happened and did a Find in the Word document for curly quotes. While in the Find screen, I quickly swapped out the curly quotes for straight quotes using the Replace function. This quickly resolved the Ovid MEDLINE error.

To prevent this from happening or to efficiently replace them, you can do a few things depending on your preferred word processing software:
 
Google Docs:
  • From the Tools menu, select Preferences, then uncheck the "Use smart quotes" box.
  • You will still need to find and replace existing smart quotes.
 
Microsoft Word (Word for Mac 16.57):
  • From the Tools menu, select "AutoCorrect Options," then under the "AutoFormat As You Type" uncheck the "straight quotes" with "smart quotes"
  • You will still need to find and replace existing smart quotes
 

 Microsoft Word (Office on the Web):
  • From the File menu, click on "Options"
  • Click on "Proofing" from the left-side menu, then click the "AutoCorrect Options" button
  • Select "AutoFormat" and unclick 'Straight quotes with "Smart Quotes"


 
BBEdit:
  • From the Text menu, you can straighten all quotes in the document.

TextEdit:
  • From the Edit menu, select Substitutions > Smart Quotes 

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