Search Results

Thanks for your reply.
consider trade file is sorted based on COB date(Close of business date)
e.g
30/10/2009,tradeid1,..,..
26/10/2009,tradeId1,..,..
30/10/2009,tradeId2,..,.....

Hi All,

I have huge trade file with milions of trades.I need to remove duplicate records (e.g I have following records)
30/10/2009,trdeId1,..,..
26/10/2009.tradeId1,..,..,,...

Can anybody please have look at this isssue?

Hi All,

I have huge trade file with milions of trades.I need to remove duplicate records (e.g I have following records)
30/10/2009,trdeId1,..,..
26/10/2009.tradeId1,..,..,,...

Hi thanks alot for solution.But this script is not considering all the records.

My input file having million records.

30/03/2009,17981-G,MIDAS,,FX Euro Option,,MELLON ADM,MELLON...

I have huge txt file having millions of trade data.
For e.g
Trade.txt (first 8 lines in the file is header info)

COB_DATE,TRADE_ID,SOURCE_SYSTEM_TRADE_ID,TRADE_GROUP_ID,...