Not able to open .gz file
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...