rafikul

Hi Experts,

I have .gz files which has data inside it like this:
Trade No. Symbol Instrument TradeDate ExpDate OptionType StrikePrice Time Price Qty
106263 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:36:06 108 1000
97100 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:19:06 107 1000
64968 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:10:35 14.95 400
74877 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:30:24 13.45 800

There are more than 2 lakh such rows in a single .gz file, in each row fields delimited by "|" character.

I have to process the data contained in more than 2000 such .gz files. For each PE entry I have to find CE entry with matching TradeDate, ExpDate,StrikePrice, and Time difference of less than 30 seconds. In the output file I need such matching PE and CE in a single row.

Again,i use netbook Linpus Linux Lite is the OS, in that a program called Xarchiver easily decompresses the file.

Any hint how to open this file...

Regards,
Rafikul

ozar

Welcome to the forums!

Check out gzip and gunzip for file compression and extraction:

The gzip home page

__________________
oz

New Members: * README *

rafikul

Hi OZAR,
Thanks for the reply.
I already decompress the .gz file.But i am not able to see its content.After extraction i got the below information:-
Trade No. Symbol Instrument TradeDate ExpDate OptionType StrikePrice Time Price Qty
106263 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:36:06 108 1000
97100 NIFTY OPTIDX 1-Apr-2005 20050428 CE 1940 12:19:06 107 1000
64968 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:10:35 14.95 400
74877 NIFTY OPTIDX 1-Apr-2005 20050428 PE 1930 11:30:24 13.45 800

Kindly give me some hint so that i am able to process the data.

Regards,
Rafikul