Terminé

Excel VBA Macro to parse and format a text file

I have a program that generates a text file that I need a macro to read and format accordingly. I've attached a sample file (requestReply) as well as sample output (MRA Macro-2). Some of the code is already written, I just don't have time to finish it.

Using the Macro-2 file as a reference, here is some more information about each sheet. Everything is color-coded as far as where it goes/pulls from. If it's not color coded it comes from the text file.

Requirements - ignore

Application - a list of applications used to populate application fields

Task - a list of tasks used to populate task fields

Request - a list of request numbers used to populate request/transaction fields

Summary - A summarized, formatted version of everything in the text file. Each application can have a 1:m relationship with tasks (list application once and each task). Each task can have a 1:m relationship with requests (list task once and each request). Requests may repeat in text file under the same task...list both twice as shown in example.

Note: Each application may be listed more than once. In the example, 3071000 repeats. They should only be listed twice if there is another application that comes in between them (4170105).

Detail - detailed version of everything listed in the text file. Application information is listed and then for each task it's information is listed. If multiple requests fall under the same transaction, the application/task information (user, appctx and domain as well) DOES NOT need to be repeated. Every single request (transaction) has a 'Request' and 'Reply'. As shown, the fields may not always be populated. Examine the way the Macro example is formatted in relation to the number of blocks located in the text file.

More information will be provided on the accepted quote, but it's basically just reading a file and formatting the data accordingly.

Compétences : Excel, Visual Basic

en voir plus : m format in excel, vba time, excel vba with, parse and, mra, fall 2015, excel vba macro, data to text file, excel sheet formatting, application vba, vba tasks, vba file list excel, visual parse file, excel macro reference, parse data file, java parse text file format, format provided, excel vba text formatting, read excel file sheet, read excel file program, tasks vba excel, example vba application, written file excel, applications excel, user information list excel

Concernant l'employeur :
( 9 commentaires ) San Diego, United States

Nº du projet : #7074985

Décerné à:

zExcel

A proposal has not yet been provided

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(142 Commentaires)
6.8

5 freelance font une offre moyenne de $76 pour ce travail

cgullapalli

Hi, I am good at excel and macros... I can create vba. Please see my experience list in the freelancer. I will create vba to meet your requirement with all the conditions satisfied. Looking forward for your re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(6 Commentaires)
2.7
SBITServices

Hi, I have understand your requirement. I am responsible,flexible,patient and optimistic.I am also very passionate about my work and honestly can provide 100% quality work and can work for 8 - 10 hrs daily (all 7 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
1.2
K9JT

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
1.1
dinomarinic

My priority is to finish this project cheap, fast and with quality output to earn good reputation. I have lot of experience with excel and vba as I use it in my daily work. I can assure you that if you work with me on Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
0.6