DUPES - URGENT
Posted: Tue May 18, 2010 8:51 pm
Hi,
I am having an input file in this structure
AAAA 1
AAAA 1
AAAA 2
BBBB 2
CCCC 3
CCCC 3
DDDD 5
EEEE 1
EEEE 1
EEEE 1
EEEE 1
EEEE 1
MY OUTPUT EXPECTED IS - ALL RECORDS THAT HAVE MORE THAN 1 RECORD ON THE COLUMNS AS LISTED
AAAA 1
AAAA 1
CCCC 3
CCCC 3
EEEE 1
EEEE 1
EEEE 1
EEEE 1
EEEE 1
PLEASE ADVISE
I am having an input file in this structure
AAAA 1
AAAA 1
AAAA 2
BBBB 2
CCCC 3
CCCC 3
DDDD 5
EEEE 1
EEEE 1
EEEE 1
EEEE 1
EEEE 1
MY OUTPUT EXPECTED IS - ALL RECORDS THAT HAVE MORE THAN 1 RECORD ON THE COLUMNS AS LISTED
AAAA 1
AAAA 1
CCCC 3
CCCC 3
EEEE 1
EEEE 1
EEEE 1
EEEE 1
EEEE 1
PLEASE ADVISE