I am sure that this tool already exists, but I could not find it.
What I need is a tool, which would take the XML dump (see attached two files) and extract the following fields into Excel Spreadsheet:
First Author First Name (first author in the author list)
First Author Last Name
Journal Name (e.g. Nature) (in XML dump it usually goes as Title)
The program should check if the last name of the first author is present in the email address. If not, first and last name of the Last Author (last author in the author list) on the publication should be used.
The program must tolerate files with twenty thousand records.
Only about 20% of entries have emails.
14 freelancers are bidding on average $88 for this job
Dear Employer We will give you the best result by using my Past experience and excellent academic skills on your project. you can chat with me and let's get started.
I will create the tool for you so that you can use it anytime. Plus I'll also customize the tool in such a way that it can be used even with other type of XMLs.
I have worked on various project on xml and excel data extraction and vice-versa You just have to take one step of trust to me and i promise that my work will never disappoint you.
I can extract your data and provide you the XML to Excel software. I have an extensive experience with data entry specialists and committed to submit the project in stipulated time