{"id":12,"date":"2016-06-22T16:52:10","date_gmt":"2016-06-22T15:52:10","guid":{"rendered":"https:\/\/blogs.ncl.ac.uk\/miscellany\/?p=12"},"modified":"2016-06-22T16:52:10","modified_gmt":"2016-06-22T15:52:10","slug":"adding-impact-factors-to-endnote-references","status":"publish","type":"post","link":"https:\/\/blogs.ncl.ac.uk\/miscellany\/2016\/06\/adding-impact-factors-to-endnote-references\/","title":{"rendered":"Adding Impact Factors to EndNote references"},"content":{"rendered":"

Based on this discussion<\/a>, a solution seemed feasible.<\/p>\n

Adding the Impact Factor to an empty field in the references themselves is probably possible,\u00a0but the Find\/Replace options within EndNote aren’t sophisticated enough to do it,\u00a0so the process\u00a0would involve exporting the Library out into Excel, running the replacements, then importing back –\u00a0which is likely to run into a load of other problems en route. Plus: any new references added to the library would need the Impact Factor adding (or the whole process to be run again).<\/p>\n

Better:\u00a0use term lists to make the replacements. You will need: EndNote’s term list (in the case I was working on it was the medical one), and a full\u00a0table of current Impact Factors downloaded in\u00a0Excel format\u00a0from Journal Citation Reports.<\/p>\n

Instructions<\/strong>\u00a0(I’m sure some of these could be refined if I was better at Excel, but this will\u00a0work):<\/p>\n

Open both the term list (as a UTF-8 tab-delimited text file) and the downloaded IF list in Excel (and paste them into the same file).<\/p>\n

You can try and tidy up the IF list a little\u00a0to match the\u00a0term list formatting (e.g. a find\/replace\u00a0“fur” -> “f\u00fcr” to cover the German journal names).<\/p>\n

In the term list, copy the full journal names into an additional column. Use Excel’s VLOOKUP function to replace that column with the appropriate value from the IF table.<\/p>\n

Copy that column as\u00a0values<\/em> into a new column (then delete the old one)\u00a0then replace “#N\/A” with just “n\/a” (or whatever you want to see if there is no IF for that journal). Fix any notable values that didn’t get picked up (e.g. BMJ\/British Medical Journal).<\/p>\n

So now hopefully you’ve got the term list with an extra column with IF values (or “n\/a” or something if it doesn’t have one). The final steps depend how you want the IF to appear.<\/p>\n

 <\/p>\n

If you’re happy for it to appear with<\/em> the journal name in the reference, e.g. Journal of Stuff (IF 2014: 3.021) <\/em>42(1) 567-578, then:<\/p>\n

Create a new column that uses CONCATENATE to combine the IF column with the full journal name column to get the\u00a0Journal of Stuff (IF 2014: 3.021) <\/em> format (or however you’d like it).<\/p>\n

Paste that column to replace the Abbreviation 1 column (and delete all columns beyond Full\/Abbreviation 1\/Abbreviation 2\/Abbreviation 3).<\/p>\n

Save as a text file. [To get the right formatting (to avoid weird glitches),\u00a0I found I had to save it from Excel as an Excel file, then open it\u00a0in Access and save it as a text file (without ” ” markers), then<\/em> open in Notepad and save as a\u00a0UTF-8 format text file. Madness.]<\/p>\n

Then you can import the term list into your EndNote library as normal (remembering to delete anything already in the journal term list before you import),\u00a0then finally\u00a0edit your style to use Abbreviation\u00a01 (without removing periods), and boom, you’re sorted<\/strong>.<\/p>\n

If you want abbreviated journal titles\u00a0in your references, then just use the Abbreviation\u00a01 or Abbreviation 2\u00a0column (depending on whether you want dots or not) in the CONCATENATE stage. I’d still always finish by replacing the Abbreviation 1 column with the modified journal name\u00a0+ IF, since journal titles\u00a0generally don’t appear in that\u00a0format when they get imported into EndNote (i.e. that column is\u00a0not needed for ‘recognising’ the journal name from your EndNote library references).<\/p>\n

 <\/p>\n

If you want the IF to appear separately to the journal name, e.g.\u00a0Journal of Stuff <\/em>42(1) 567-578 (IF 2014: 3021), then:<\/p>\n

Paste just the IF (just the number) into the Abbreviation 1 column. Save as a UTF-8 text file without ” ” markers in the elaborate way\u00a0mentioned above.<\/p>\n

Now, in your EndNote library, first make sure the values in the\u00a0‘Journal’ field is correct for all references\u00a0(so if you have results from PubMed (which for mysterious reasons\u00a0includes an abbreviated journal title in the ‘Journal’ field and the full name in ‘Alternative Journal’), identify those references, select them all and use\u00a0Tools > Change\/Move\/Copy fields…<\/em> to move ‘Alternative Journal’ field values to ‘Journal’). Then use the Change\/Move\/Copy on the whole library to copy the ‘Journal’ field to an unused field (e.g. ‘Tertiary Title’).<\/p>\n

Finally, import the IF-enhanced\u00a0term list, then\u00a0modify your style so that the journal article template features ‘Tertiary Title’ where the journal name needs to be and ‘Journal’ where the IF needs to be, and choose to use ‘Abbreviation 1’ for abbreviation format. Bosh!<\/strong><\/p>\n

 <\/p>\n

Obviously,\u00a0once you’re using any of these systems, if you spot any journal names that are missing the correct IF, just edit the term list appropriately.<\/p>\n

 <\/p>\n

Hmm, writing that all down,\u00a0it sounds pretty bad, but honestly,\u00a0it’s actually not\u00a0too fiddly – and it works!<\/p>\n","protected":false},"excerpt":{"rendered":"

Based on this discussion, a solution seemed feasible. Adding the Impact Factor to an empty field in the references themselves is probably possible,\u00a0but the Find\/Replace options within EndNote aren’t sophisticated enough to do it,\u00a0so the process\u00a0would involve exporting the Library out into Excel, running the replacements, then importing back –\u00a0which is likely to run into … Continue reading “Adding Impact Factors to EndNote references”<\/span><\/a><\/p>\n","protected":false},"author":1915,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[4,5,6,7],"class_list":["post-12","post","type-post","status-publish","format-standard","hentry","category-endnote","tag-endnote","tag-endnote-styles","tag-endnote-term-lists","tag-jcr-impact-factors"],"_links":{"self":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts\/12","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/users\/1915"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/comments?post=12"}],"version-history":[{"count":1,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts\/12\/revisions"}],"predecessor-version":[{"id":13,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/posts\/12\/revisions\/13"}],"wp:attachment":[{"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/media?parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/categories?post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ncl.ac.uk\/miscellany\/wp-json\/wp\/v2\/tags?post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}