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

Suoritettu Julkaistu 3 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

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.

Excel Visual Basic Microsoft Office

Projektin tunnus: #26565434

Tietoa projektista

24 ehdotusta Etäprojekti Aktiivinen 3 vuotta sitten

Myönnetty käyttäjälle:

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 1 päivässä
(1 arvostelu)
0.5

24 freelanceria on tarjonnut keskimäärin €20 tähän työhön

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 1 päivässä
(114 arvostelua)
6.7
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 Lisää

€8 EUR 1 päivässä
(80 arvostelua)
6.0
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 Lisää

€25 EUR 1 päivässä
(41 arvostelua)
5.2
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 Lisää

€10 EUR 1 päivässä
(82 arvostelua)
5.0
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 Lisää

€27 EUR 2 päivässä
(22 arvostelua)
4.7
workguruu

Hello Lets start it now to deliver back for shortest time. so that you can proceed forward with your content. Should we talk ?Waiting

€30 EUR 1 päivässä
(0 arvostelua)
0.0
shivanidubey487

I give you the best result as you want. Relevant Skills and Experience Worked with excel and data entry.

€23 EUR 1 päivässä
(0 arvostelua)
0.0
amirulislam8391

Dear sir , I will be perfectly do your work , I am a professional Microsoft office expert, I have more than 6 years experience in real life, I am new here but expert with Microsoft office, please give me a chance , I a Lisää

€20 EUR 7 päivässä
(0 arvostelua)
0.0
mcrahul

I am an expert in Excel work and have industrial experience of 1 year. Since I am a beginner in freelancing I can offer free work and expecting a good rating for the work I have done.

€8 EUR 1 päivässä
(0 arvostelua)
0.0
monishk716

I m working on excel since last 5 year. I am quite good in excel you can trust me. I can do your work with in given time frame I only deliver a high-Quality Job. I Love to hear Hi from you. Thank you

€14 EUR 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 Lisää

€12 EUR 2 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 Lisää

€20 EUR 7 päivässä
(0 arvostelua)
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 Lisää

€23 EUR 10 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
iamshfiqjaan

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 assu Lisää

€19 EUR 1 päivässä
(0 arvostelua)
0.0