For a research project I need to transform the txt data export of the results of a scientific search engine in to the correct excel format. The metadata of a scientific contribution is represented block-wise in the txt file - there the title is represented with a T in the beginning, authors with an A, journal types with aB, publication date with a D and the abstract with a X (all others fields are not relevant). As every publication has a different number of authors or some fields are not filled out, every "block" has a different length which makes it quite hard for me to automate the transposition. In the end I want the data to look like in the provided screenshot showing the title, authors, journal type, year and abstract row-wise. (screenshot shows the desired solution for the first "block" of the txt file)
I have 4 of those txt files with overall about 700 of those publications which I want in two excel sheets.
Hello, This is what I do in my everyday research life. Working with XLSX,XLS and CSV files, formatting for specific purposes is a regular job for me. I can do it well for you. ~Cheers Krishna
27 freelancers are bidding on average €19 for this job
hello there, i am willing to put in the hours and provide you with clean data as you've illustrated in the screenshot. looking forward to hearing from you. regards, [login to view URL]
Hi sir I can perform this task because of my experience in the data entry field its a piece of cake for me and its a simple task. The project will be delivered to you in 3 days.
I have a great experience in excel sheet and worked for a private firm as an internee but got an appreciation certificate and also got some bonus on it that's why i am capable for it.
Dear Hiring manager I am an expert excel freelancer. I can do it with in 3day. Relevant Skills and Experience I am a Web designer Microsoft offic, excel,PowerPoin, word expert.
i believe im right person for that, im expert in excel for 15 years, almost most kinds of issues passed to me, and solutions is exist , will be happy to discuss in inbox for more details