Em Andamento

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

Ver mais: log into, excel command line, continue line, 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, csv convert, excel input interface, save file directory, convert output, csv excel text, directory convert application, csv files processing, csv text file, convert log file excel, csv file input

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

ID do Projeto: #5092928

Premiar a:

wbslivera

Hello, I am oracle certified professional java programmer and have Bsc.IT, Beside I have done three similar works before, thanks

$50 USD em 1 dia
(4 Avaliações)
3.4

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

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 dias
(33 Comentários)
4.4
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 em 1 dia
(21 Comentários)
4.2
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 Mais

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

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

$147 USD in 4 dias
(23 Comentários)
4.0
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 dias
(2 Comentários)
3.3
rumana17

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)
2.9
pilotarif

Hello, First of all let me introduce myself. I am a B.Sc Electrical and Electronic Engineer & M.Sc 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)
2.9
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 dias
(3 Comentários)
1.9
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 em 1 dia
(2 Comentários)
1.7
mailsmaity

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 - mail.smaity

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

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

A proposal has not yet been provided

$35 USD em 1 dia
(0 Comentários)
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 dias
(0 Comentários)
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 Mais

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