EBK has asked for the wisdom of the Perl Monks concerning the following question:
The column 0 there is a unique key and I have groups of keys. I need to print the difference between them. For example my group 1 is ABCD_FH. So I want to print 9 positions of group ABCD_FH and reserved them. key_683 up to key_694.key_683,march,29031990,ABCD_FH,9,9 key_684,march,29031990,ABCD_FH,9,9 key_685,march,29031990,ABCD_FH,9,9 key_686,march,29031990,ABCD_FH,9,9 key_687,march,29031990,ABCD_FH,9,9 key_688,march,29031990,ABCD_FH,9,9 key_689,march,29031990,ABCD_FH,9,9 key_693,march,29031990,ABCD_FH,9,9 key_694,march,29031990,ABCD_FH,9,9 key_683,march,29031990,ABCD_H + ABC_F,8,17 key_684,march,29031990,ABCD_H + ABC_F,8,17 key_685,march,29031990,ABCD_H + ABC_F,8,17 key_686,march,29031990,ABCD_H + ABC_F,8,17 key_687,march,29031990,ABCD_H + ABC_F,8,17 key_688,march,29031990,ABCD_H + ABC_F,8,17 key_689,march,29031990,ABCD_H + ABC_F,8,17 key_690,march,29031990,ABCD_H + ABC_F,8,17 key_691,march,29031990,ABCD_H + ABC_F,8,17 key_692,march,29031990,ABCD_H + ABC_F,8,17 key_693,march,29031990,ABCD_H + ABC_F,8,17 key_694,march,29031990,ABCD_H + ABC_F,8,17 key_695,march,29031990,ABCD_H + ABC_F,8,17 key_696,march,29031990,ABCD_H + ABC_F,8,17 key_697,march,29031990,ABCD_H + ABC_F,8,17 key_698,march,29031990,ABCD_H + ABC_F,8,17 key_699,march,29031990,ABCD_H + ABC_F,8,17 key_683,march,29031990,ABC_H + AB_F,2,19 key_684,march,29031990,ABC_H + AB_F,2,19 key_685,march,29031990,ABC_H + AB_F,2,19 key_686,march,29031990,ABC_H + AB_F,2,19 key_687,march,29031990,ABC_H + AB_F,2,19 key_688,march,29031990,ABC_H + AB_F,2,19 key_689,march,29031990,ABC_H + AB_F,2,19 key_690,march,29031990,ABC_H + AB_F,2,19 key_691,march,29031990,ABC_H + AB_F,2,19 key_692,march,29031990,ABC_H + AB_F,2,19 key_693,march,29031990,ABC_H + AB_F,2,19 key_694,march,29031990,ABC_H + AB_F,2,19 key_695,march,29031990,ABC_H + AB_F,2,19 key_696,march,29031990,ABC_H + AB_F,2,19 key_697,march,29031990,ABC_H + AB_F,2,19 key_698,march,29031990,ABC_H + AB_F,2,19 key_699,march,29031990,ABC_H + AB_F,2,19 key_700,march,29031990,ABC_H + AB_F,2,19 key_701,march,29031990,ABC_H + AB_F,2,19
Now is the magic, the group 1 I will use the keys I have reserved and print the leftovers from group 2 - ABCD_H + ABC_F and printingkey_683,march,ABCD_FH,9,9 key_684,march,ABCD_FH,9,9 key_685,march,ABCD_FH,9,9 key_686,march,ABCD_FH,9,9 key_687,march,ABCD_FH,9,9 key_688,march,ABCD_FH,9,9 key_689,march,ABCD_FH,9,9 key_693,march,ABCD_FH,9,9 key_694,march,ABCD_FH,9,9
And the group 3 the leftovers from group 1 and group 2,key_690,march,ABCD_H + ABC_F,8,17 key_691,march,ABCD_H + ABC_F,8,17 key_692,march,ABCD_H + ABC_F,8,17 key_695,march,ABCD_H + ABC_F,8,17 key_696,march,ABCD_H + ABC_F,8,17 key_697,march,ABCD_H + ABC_F,8,17 key_698,march,ABCD_H + ABC_F,8,17 key_699,march,ABCD_H + ABC_F,8,17
So my final file will be.key_700,march,ABC_H + AB_F,2,19 key_701,march,ABC_H + AB_F,2,19
key_683,march,ABCD_FH,9,9 key_684,march,ABCD_FH,9,9 key_685,march,ABCD_FH,9,9 key_686,march,ABCD_FH,9,9 key_687,march,ABCD_FH,9,9 key_688,march,ABCD_FH,9,9 key_689,march,ABCD_FH,9,9 key_693,march,ABCD_FH,9,9 key_694,march,ABCD_FH,9,9 key_690,march,ABCD_H + ABC_F,8,17 key_691,march,ABCD_H + ABC_F,8,17 key_692,march,ABCD_H + ABC_F,8,17 key_695,march,ABCD_H + ABC_F,8,17 key_696,march,ABCD_H + ABC_F,8,17 key_697,march,ABCD_H + ABC_F,8,17 key_698,march,ABCD_H + ABC_F,8,17 key_699,march,ABCD_H + ABC_F,8,17 key_700,march,ABC_H + AB_F,2,19 key_701,march,ABC_H + AB_F,2,19
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: I want to remove duplicate based on specific column and value.
by hippo (Archbishop) on May 25, 2018 at 09:02 UTC | |
|
Re: I want to remove duplicate based on specific column and value.
by Veltro (Hermit) on May 25, 2018 at 07:32 UTC | |
|
Re: I want to remove duplicate based on specific column and value.
by mr_ron (Deacon) on May 25, 2018 at 14:42 UTC |