Convert text file into CSV or spreadsheet

Completed Posted Nov 4, 2013 Paid on delivery
Completed Paid on delivery

This is a simple project to convert a text file to a CSV file that can be imported into a spreadsheet.

The attached file has a sample of the text file to be converted. Each line in the text file is a log file message. I want all of the individual lines for each date and time stamp to be combined so that all of the messages for any one date and time are on a single line, separated by commas.

The logic for processing this file is this:

- Read each line in the order in which it appears in the file.

- For each line that has a date and time, read the text of that line and each of the lines immediately following that date and time and combine them so that each of them is on a single line, separated by a comma.

- Continue doing this until you reach the next line with a date and time

Repeat the process until all lines are read.

When all of the lines in the text file are processed, save the result in a file with a CSV extension.

An example of the output of this process is the second attached file.

I will be importing the resulting file in a spreadsheet. If the size of the file is too large to be imported into Excel, I have the tools available to select the lines that I need so you do not need to worry about that.

I will want the source code this project and will send you the actual file for you to process so you can demonstrate that the code works. You can use any language but you need to tell me what you will use in your bid.

A command line interface is fine for this project. Users should be able to type the name of the application, then be prompted for the filename to be processed, then be prompted for the filename to be output. Both input and output files are assumed to be in the same directory as the application file.

I want to get this job done ASAP, so you MUST agree to meet your proposed delivery time. If you do not deliver as agreed, your payment will be reduced by 1/3rd for a delay of 1 day, 50% for a delay of 2 days and 2/3rds for a delay of 3 days. By bidding on this, you are agreeing to this condition.

I will only post 1/2 of the project fee as a milestone payment. Do not ask for more.

Excel

Project ID: #5092928

About the project

15 proposals Remote project Active Nov 4, 2013

Awarded to:

wbslivera

Hello, I am oracle certified professional java programmer and have [login to view URL], Beside I have done three similar works before, thanks

$50 USD in 1 day
(21 Reviews)
4.4

15 freelancers are bidding on average $85 for this job

Ibrahim185

sir, i am highly interested and dedicated to do this task.I am agree with your condition. let's start. i am awaiting for your positive reply. thanks

$50 USD in 1 day
(640 Reviews)
7.8
flashsaiful

Hi dear Sir, I can do this for you... ...thanks

$147 USD in 4 days
(140 Reviews)
6.6
rengrish

VBA expert here. I can do this using macros .Please let me know . Please check my past reviews and ratings. I have very good experience in this fiield.

$83 USD in 3 days
(146 Reviews)
5.9
prakashmondal

hi, I will provide you and windows software application to read from txt file and write into excel or csv according to the requirement. I will use .net(c#). The application will read from a configurable directory and More

$50 USD in 2 days
(14 Reviews)
4.7
inoussakabore

I have already done this kind of job.i am a statistician engineer working as a data manager and data analyst there is 4 years. What you want it's what i master a lot. I am ready to start it for you.

$74 USD in 3 days
(3 Reviews)
3.3
AccuPro

Hello, I can do this real quick! Do let me know if you are interested. Best regards, AccuPro - Providing simple solutions to complex problems!

$60 USD in 2 days
(5 Reviews)
2.8
ziafar

hello i am expert in VBA and Excel. i can use VBA to perform your need. at your disposal for anay more information. regards

$84 USD in 1 day
(3 Reviews)
2.9
MarkoWizz

Hello, I have already worked with data entry and I have experience using excel. I am a honest freelancer and I am sure we can do this. I am also available to start right now. Don’t hesitate to contact me.

$111 USD in 3 days
(0 Reviews)
0.0
shashankbs

A proposal has not yet been provided

$35 USD in 1 day
(0 Reviews)
0.0
alihassan76

I done this job as part time, although I do not done such job before, but I could done this job successfully. so I take this time to compleate. feel free to discuss with me

$111 USD in 7 days
(0 Reviews)
0.0
shehzadwork

I have the required skills and expertise. I can do your this project. I will be able to complete the work within 1 day. I have also designed and developed many desktop based applications in C# and Java. I can do this w More

$89 USD in 1 day
(0 Reviews)
0.0