Create csv-files from program output
Closed - This job posting has been filled and work has been completed.
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:
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.