I have a SQL server machine that has Perl on it. No one currently with the company knows how to use Perl. Unfortunately for me, I am supposed to come up with the answer to the following question, oh, like yesterday!
I apologize in advance for my ignorance, but what little I do know of Perl is that it seems like it would solve the current problem readily.
We have a very large fixed length field text file which is used as the source for a reporting database. It has only one 'unique' field (message ID). The problem is that in freakish system situations bogus records get written to the log which result in duplicate records or records with the same message ID.
How would I go about stripping out all occurences of records containing the non unique references to the message ID, EXCEPT the last record (this is the one that actually got delivered)?
Any guidance is greatly appreciated. I will be reading my recently aquired O'reilly Perl books on the train....
I apologize in advance for my ignorance, but what little I do know of Perl is that it seems like it would solve the current problem readily.
We have a very large fixed length field text file which is used as the source for a reporting database. It has only one 'unique' field (message ID). The problem is that in freakish system situations bogus records get written to the log which result in duplicate records or records with the same message ID.
How would I go about stripping out all occurences of records containing the non unique references to the message ID, EXCEPT the last record (this is the one that actually got delivered)?
Any guidance is greatly appreciated. I will be reading my recently aquired O'reilly Perl books on the train....