topic Re: Delete adjacent duplicates in Application Development and Automation Discussions

Delete adjacent duplicates

Former Member — Thu, 10 Jul 2008 05:56:07 GMT

I am having entries like this in my internal table..


    x             y
    23           12
     -              -
    23           25
     -             12

sort itab by x.

( so it will get changed like this)

 x             y
           -              -
           -             12
           23           25
            23           12

delete adjacent dupilcates from itab comparing x.

but my requirement is i dont want to delete the blank entries in x.

Thanks and Regards,

Arun Joseph

Re: Delete adjacent duplicates

Former Member — Thu, 10 Jul 2008 06:32:41 GMT

Can any one help me out how to make this??

Re: Delete adjacent duplicates

Former Member — Thu, 10 Jul 2008 06:35:46 GMT

Move the blank values (for field x) in your original internal table(itab) to another internal table(itab2) and delete the duplicates from the original internal table(itab). Then append the values back from the new internal table(itab2) back into the original internal table(itab).

Manoj

Re: Delete adjacent duplicates

venkatasriram_mygapula — Thu, 10 Jul 2008 06:53:20 GMT

Hi,

i think with in the loop try this.

if x is not initial.

delete adjacent duplecates comparing x.

endif.

regards.

sriram.

Re: Delete adjacent duplicates

Former Member — Thu, 10 Jul 2008 06:58:02 GMT

Can you please bit more specific?

Re: Delete adjacent duplicates

venkatasriram_mygapula — Thu, 10 Jul 2008 07:05:28 GMT

Hi,

supppose your internal table is ITAB having fields like X,Y

X Y

10 10

-- 15

10 10

--- 20

15 25.

when you are writing the data.

loop at itab.

if itab-x is not initial.

delete adjacent duplecants from itab comparing x.

write:/ x,

endif.

endloop.

regards.

sriram.

Re: Delete adjacent duplicates

former_member787646 — Thu, 10 Jul 2008 07:15:10 GMT

Hi,

Try this..

Delete Adjacent Dupilcates from itab comparing all fields.

Hope it helps you.

Murthy

Re: Delete adjacent duplicates

Former Member — Wed, 17 Sep 2008 02:26:27 GMT

Thanks