Completed

I need an excel expert for formatting a txt file in ecxel

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.

Skills: Excel, Visual Basic, Microsoft Office

See more: convert excel to text file with delimiter, how to open csv file in excel with columns, convert excel column to text file separated by commas, formatting is lost when reopen excel worksheet, text import wizard excel, open csv file in excel without formatting, convert text file to excel 2016, how to convert excel file to text file with comma delimited, need excel expert, excel macro write txt file, excel macro create txt file, excel script import txt file, excel macro read txt file, excel macro read txt file internet, excel write log txt file, excel macro convert txt file xls, need excel expert match columns, need excel expert create macro, i have a html email template i have need a expert who make it responsive for pc tablet and mobile need complete it today after t, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s

About the Employer:
( 0 reviews ) München, Germany

Project ID: #26565434

Awarded to:

dreamvisualizer7

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

€10 EUR in 1 day
(0 Reviews)
0.0

27 freelancers are bidding on average €19 for this job

daniyal3214

I can perfectly help you with that. I am an advance level Excel user holding years of experience. I will be happy to discuss in detail.

€30 EUR in 1 day
(70 Reviews)
5.7
MartinDudumi

Hi there, I'd like to be considered for your request. I’m a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can ass More

€25 EUR in 1 day
(25 Reviews)
4.8
bktk

Sir YOUR SATISFACTION IS MY PRIORITY. Hello, this is very simple for me, sir I will do this project of formatting publication in excel very well and perfectly right now within 24 hours. If you are interested in workin More

€10 EUR in 1 day
(55 Reviews)
4.4
imtyzooel71n

Hello Dear, Can we discuss more? I can formatting a txt file in excel with 100% accuracy right now. If you need any sample please let me know. I am expert and have great working experience in Lead Generation, Web S More

€8 EUR in 1 day
(13 Reviews)
3.5
Jatin77777

Hello, I have gone through with contents and understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just ping me once. I More

€27 EUR in 2 days
(6 Reviews)
2.8
musangi

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]

€30 EUR in 7 days
(0 Reviews)
0.0
RadhaTechM

I have gone through your requirement and I am very confident that I can handle this request. I have good knowledge in that Would like to ask you to allow us to work for you Looking forward for your positive respon More

€10 EUR in 3 days
(0 Reviews)
0.0
afaqahmad2748

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.

€8 EUR in 7 days
(0 Reviews)
0.0
€23 EUR in 1 day
(0 Reviews)
0.0
Ravishan2211

Hi I can do this project as in the screenshot and possible time and with the highest quality if you trust my skills. thank you

€20 EUR in 3 days
(0 Reviews)
0.0
mpmalabika

I am Data Entry expert. I am proficient in typing and transcriptions. I will do your work with responsibility and delivery in time. Relevant Skills and Experience I am proficient in Excel , Word, Access, PowerPoint pr More

€23 EUR in 10 days
(0 Reviews)
0.0
€30 EUR in 3 days
(0 Reviews)
0.0
HiraMarrium

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.

€19 EUR in 7 days
(0 Reviews)
0.0
Fatom112

Hello there ! It's Fatima Farhan. I am a researcher and i have worked with different types of data. I have great experience with excel, Microsoft office and visual basic since i have been using those tools for more tha More

€20 EUR in 7 days
(0 Reviews)
0.0
akimranbd

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.

€24 EUR in 3 days
(0 Reviews)
0.0
diab132

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

€17 EUR in 7 days
(0 Reviews)
0.0
anooshakafeel112

Hey hope you will fine .I am expert in excel, PowerPoint,word ,PDF converter ,web researching and typing . If you consider me as your employee I will do this project free if you agree and I hope you will be interested More

€12 EUR in 2 days
(0 Reviews)
0.0
maxwell707

Hello I can do this project in the shortest possible time and with the highest quality and you will be satisfied if you trust my skills. thank you

€19 EUR in 7 days
(0 Reviews)
0.0
MBILALMEHDI

Hi, I am a data entry expert and done many projects. kindly reply me I convert your file and I will show your file

€19 EUR in 7 days
(0 Reviews)
0.0
mughiesn

Will complete this task within 6hours Relevant Skills and Experience Certified Excel, Microsoft word

€19 EUR in 1 day
(0 Reviews)
0.0