@pdmosier wrote:
One last question–Is there an easy way to replace the journal name in the Journal field for each existing reference “master record” (i.e. the information that is displayed in the Journal field in the “Referenece” tab? These still retain their original abbreviated names; I’d like to change these to the full journal titles so that they match the Full Title column in the journals term list. I could export the references using a predefined style, edit the journal name, and import them back into EndNote, but then some information would be lost (such as the Notes).
Thanks for the update and glad it worked out. As for your last question, it isn’t necessary to change the abbreviated names to the complete Journal names. If you want to pursue doing so using Endnote there are 2 options: 1) Find and Replace (go to the toolbar and select Edit >5 and Replace); or 2) Change/Move/Copy Fields (go to the toolbar and select Tools > Change Move Copy). (Since the The Change/Move/Copy Fields option replaces the entire field you’ll first need to pre-sort the references by journal title. Then you would be able to select a group and change the journal title for that group.) Before proceeding with either method, you might want to copy the journal title field into another field for safekeeping.
There’s a quicker and easier method using MS Excel and the VLOOKUP function but calls for exporting the Endnote records and the journal terms files. The process is to:
- Export the journal terms list and the Endnote records as text files. (Note: before exporting the Endnote records, presort the records in ascending order by the journal title field. Also, If using the Tab Delimited output style to export the records you may need to first place carriage returns at the end of certain fields so the data remains intact. Refer to this thread for further detail.)
- Open the journals term list and Endnote records in MS Excel, creating 2 worksheets. Then copy one worksheett into the second worksheet so both are in the same workbook . (Refer to image 1). For this example, each worksheet has been named “terms” and “library”and fields both the number of records and fields have been decreased to facilitate the illustrations.
- a. Insert two columns on the left side (column A and B). Copy the list of abbreviated journal titles into column A (this will serve as the reference point). The blank column B is where the vlookup function will return the complete journal title when found on the journal terms worksheet.
