Create csv-files from program output

Create csv-files from program output

Closed - This job posting has been filled and work has been completed.

Job Description

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

Open Attachment

Other open jobs by this client