As per one of my business requirement data looks as mentioned below.
1234 BALU 00000
1234 RAVI 98767
1234 GANI 00000
3456 SURI 67859
9876 BALT 98767
1234 RAVI 98767
1234 GANI 00000
3456 SURI 67859
9876 BALT 98767
I 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
