Create csv-files from program output

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 2 years ago

Fixed Price

Delivery by April 20, 2013

$45.00

Budget

Details

Hi!

I have a bash script that generates data that needs to be ordered into csv-files.

The project is to add a code-snippet to the script. This code snippet will create csv-files from the generated output.

The output is in the attached file.

There are requests with request numbers(here 1 & 2) on lines like these:
2013-03-20 15:22:12.491 REQ_MKT_DATA 1 'JCP' 'SMART' 'OPT' '20130322' 'P' '11.5' 'USD' 'JCP   130322P00011500' '' 0
2013-03-20 15:22:12.491 REQ_MKT_DATA 2 'JCP' 'SMART' 'OPT' '20130322' 'P' '11' 'USD' 'JCP   130322P00011000' '' 0

Then there are replies with corresponding request numbers (here 10) on lines like these:
2013-03-20 15:22:13.148 TICK_PRICE: 10 JCP 124075526 lastPrice 0.05
There are many replies but for each request we are only interested in lastPrice.

This data should be output with timestamp to a csv file named eg. JCP130316P00010000.csv corresponding to the field in the query.
The format of the csv file should be:
"Index","JCP130316P00010000.Close"
2013-02-19 09:30:00,0.030000

If you think you can do this please bid and briefly describe which command line tool you prefer to use. This is a relatively simple task. Full SSH access to ubuntu server with the script will be provided. No need to do any own setup.

---
Skills: linux


About the Client

(4.26) 51 reviews

Estonia
Tallinn 11:42 AM

122 Jobs Posted
67% Hire Rate, 1 Open Job

Over $10,000 Total Spent
97 Hires, 3 Active

$15.02/hr Avg Hourly Rate Paid
281 Hours

Member Since Nov 15, 2011