I am having my data in mysql table called sms_log the fields are sender.receiver,sent the sender fields format is sender receiver sent xyz abc <[EMAIL PROTECTED]> 983434324234 2003-09-09 09:09:00 sss.ppp <[EMAIL PROTECTED]> 87323232223 2003-08-07 10:08:00
I am having one text file the format is
xyz.abc : accounts : mumbai sss.ppp : legal : pune
compare the sender fields portion ie after < sign and before @ sign ie xyz.abc with text file xyz.abc and print the report
sender: xyz.abc department:account branch:mumbai ---------------------------------------------- receiver sent ------------------------------------------- 983434324234 2003-09-09 09:09:00
---------------------------------------------
sender:sss.ppp department:legal branch:pune ---------------------------------------------- receiver sent ------------------------------------------- 87323232223 2003-08-07 10:08:00 ---------------------------------------------
how to write a perl program for this
---NOTICE--------------------------------------------------------------------------------------------------
This E-mail (including the attachment/(s) if any ) has been scanned for viruses and dangerous content. For more information mail to [EMAIL PROTECTED]
-----------------------------------------------------------------------------------------------------------
---DISCLAIMER----------------------------------------------------------------------------------------------
The contents of this E-mail (including the contents of the enclosure/(s) or attachment/(s) if any) are privileged and confidential material of Bennett, Coleman & Co. Ltd. (BCCL)and should not be disclosed to, used by or copied in any manner by anyone other than the intended addressee/(s). If this E-mail (including the enclosure/(s) or attachment/(s) if any ) has been received in error, please advise the sender immediately and delete it from your system. The views expressed in this E-mail message (including the enclosure/(s) or attachment/(s) if any) are those of the individual sender.
-----------------------------------------------------------------------------------------------------------
