Hi folks - first time user. I’m trying to use Endnote to make a list of instances in which an author has participated in a title. The goal is to count how many times an author contributed to the collection of articles. Currently querying PubMed and CINAHL, if anyone is familiar with those.
“Article 1”; Authors: Author, First; Author, Second; Author, Third; 6/16/2018
“Article 2”; Authors: Author, First; Author, Eighth; 1/5/2017
“Article 3”; Authors: Author, Third; Author, Twentieth"; 2/25/2012
Would convert to a table with:
Author, First “Article 1” 6/16/2018
Author, First “Article 2” 1/5/2017
Author, Second “Article 1” 6/16/2018
Author, Third “Article 1” 6/16/2018
Author, Third “Article 3” 2/25/2012
Author, Eighth “Article 2” 1/5/2017
Author, Twentieth “Article 3” 2/25/2012
I’m currently able to do this with Excel using their Data Import on an XML export, but I have to massage one of the XML exports (the one from CINAHL has the authors list set up in a way that thwarts the import), so I’m doing it twice every time.
I was hoping Endnote might be able to do it more efficiently and effectively than my XML imports. Is there a Style that already works for creating a library of Authors and their work?
Feel free to point me to any previous posts relevant to the question, and my apologies for any duplication.