Sort and remove dups

skgupta81 · New User Joined: 11 Nov 2008 Posts: 27 Location: Canada

I have below case where I want to remove dups.

I have values in column 1 and column 2.
Well the same row can exist in the file with column values exchanged. But I would like to remove the second such row(which is kind of duplicate according to above rule)

For ex: (INPUT) (my file has exactly same format and is 80 char in length)
AAA BBB
CCC DDD
BBB AAA
DDD CCC
XXX YYY

The output should contain only unique records.
AAA BBB
CCC DDD
XXX YYY

the other two are removed because they were already there with columns exchanged.

Any idea if I can do it through SORT/DFSORT/ICETOOL instead of cobol?

Marso · Posted: Sun Jan 04, 2015 6:38 pm

That is quite easy.
This works with the other sort product, it should work with DFSORT as well:

skgupta81 · New User Joined: 11 Nov 2008 Posts: 27 Location: Canada

Thanks for your help.