Convert text file into CSV or spreadsheet

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.

Habilidades: Excel

Veja mais: log into, excel command line, convert a file, continue line in c, command line excel, combined result, csv spreadsheet, text file, milestone or, combine excel, spreadsheet csv, convert line, save excel read, csv post, convert order, convert code excel, excel log log spreadsheet, csv convert, excel input interface, save file directory, convert output, csv excel text, directory convert application, csv files processing, csv text file

Acerca do Empregador:
( 84 comentários ) Charlotte, United States

ID do Projeto: #5092928

Concedido a:


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 em 1 dia
(4 Comentários)

16 freelancers estão ofertando em média $95 para esse trabalho


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 dias
(33 Comentários)

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 em 1 dia
(21 Comentários)

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 Mais

$50 USD in 2 dias
(9 Comentários)

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

$147 USD in 4 dias
(23 Comentários)

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 dias
(2 Comentários)

hi! let me start the project. have done similar work in past. waiting for your reply. thanks.................

$250 USD in 3 dias
(3 Comentários)

Hello, First of all let me introduce myself. I am a [login to view URL] Electrical and Electronic Engineer & [login to view URL] is going on and besides this, freelancing is my hobby as well as my main source of income and I am a hardcore freelance Mais

$88 USD in 3 dias
(9 Comentários)

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 dias
(3 Comentários)

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 em 1 dia
(2 Comentários)

I can do that through script..Will deliver you with in a day.. Ready to work on this.. will deliver project with in time. please assign to me. looking forward to work with you my skype id - [login to view URL]

$88 USD in 2 dias
(1 Comentário)

I would like to introduce me as a data entry specialist. I have more experience on data entry. I’ve done several jobs here with 5 star feedback scores. I am interested to work on the project . I can ens Mais

$155 USD in 3 dias
(0 Comentários)

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 dias
(0 Comentários)

A proposal has not yet been provided

$35 USD em 1 dia
(0 Comentários)

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 dias
(0 Comentários)

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 Mais

$89 USD em 1 dia
(0 Comentários)