Forgot to point one another thing here, so i am updating my post
In the below file , i need the o/p is as follows. The 2'nd cloumn is the Custno and is having duplicates I need to pick only the latest one and the other to be moved to a seperate file. Could some one share your thoughts? one more thing here is the custno "315307220" & '0315307220" can come in the file and this is duplicate one Input 100000001 496120145 2011-11-17-16.16.37.192280 100000002 496120145 2012-08-13-23.29.58.889499 100000003 315307220 2012-08-13-23.37.11.974326 100000003 0315307220 2012-06-13-23.37.11.974326 100000004 465464516 2012-08-13-23.56.32.610649 Output1 100000002 496120145 2012-08-13-23.29.58.889499 100000003 315307220 2012-08-13-23.37.11.974326 100000004 465464516 2012-08-13-23.56.32.610649 Output2 100000001 496120145 2011-11-17-16.16.37.192280 100000003 0315307220 2012-06-13-23.37.11.974326 Regards Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
