Find-sort duplicates to unique values

Sample Text Which I Receive Sample Text Which I Receive                
FLAGS STAMP# DATE     EXP: 1 FLAGS STAMP# DATE          
3 89471735 Nov 07 2017       3 89471735 Oct 25 2017, Nov 07 2017          
3 89471735 Oct 25 2017       3 89520137 Nov 07 2017, Oct 25 2017          
3 89520137 Nov 07 2017                      
3 89520137 Oct 25 2017     1. Flag 3 Date (Nov 07 2017) Is Overlapping In Stamp# (89471735 And 89520137), Which Should Be Considered As Overlapping Date, So We Have To Capture Nov 07 2017 For 89471735 And 89520137 Which Are In Flag 3. The Above Exp:1 Shows The Output.
7 105533682 Oct 05 2018    
7 105533682 Sep 28 2018    
7 105809307 Sep 28 2018                      
16 83859915 Jul 19 2017                      
16 83859915 Jun 08 2017                      
16 83859915 Jun 30 2017     EXP: 2 FLAGS STAMP# DATE          
16 83860108 Jun 08 2017       7 105533682 SEP 28 2018          
24 76152291 Dec 05 2016       7 105809307 SEP 28 2018          
24 76152291 Nov 08 2016                      
24 76152291 Nov 09 2016     2. Flag 7 Date (Sep 28 2018) Is Overlapping In Stamp# (105533682 And 105809307), Which Should Be Considered As Overlapping Date, So We Have To Capture Sep 28 2018 For 105533682 And 105809307 Which Are In Flag 7. The Above Exp:2 Shows The Output.
24 76162010 Dec 08 2016    
24 76162010 Nov 07 2016    
24 76162010 Nov 08 2016                      
24 76203609 Nov 14 2016                      
31 84998855 Aug 01 2017                      
31 84998855 Jul 25 2017                      
31 84998855 Jul 25 2017                      
31 84998855 Jul 27 2017                      
31 84998855 Jun 27 2017                      
31 85325018 Aug 08 2017                      
31 85325018 Jul 06 2017                      
31 85343443 Jul 06 2017                      
31 85343489 Jul 06 2017                      
                           

By: Rajsha

Leave a Reply

Your email address will not be published. Required fields are marked *