As per one of my business requirement data looks as mentioned below.
Code: Select all
1234 BALU 00000
1234 RAVI 98767
1234 GANI 00000
3456 SURI 67859
9876 BALT 98767I would like to perform delete on the last field (last 5 bytes).
Here according to the data 1st record and 3rd records are having the same data in the last 5 bytes as 00000 which is considered as duplicate.
Also 2nd and 5th record are having the same data in the last 5 bytes as 98767 which is considered as duplicate.
However, as per the requirement I would like to consider only the last 5 bytes for duplicate issue if the data is not equal to 00000.
Could you please help me with this.
Regards,
Balesh GG