To copy duplicates from two files in to one file

siva2 · New User Joined: 10 Feb 2006 Posts: 7

is it possible to copy duplicates from two files in to one file ?
if please leeme know how can it be done ? ?
file 1 :

abc
ddd
fff

file 2

eee
ddd
ggg

file 3

ddd

Frank Yaeger · Posted: Wed May 02, 2007 8:33 pm

Here's a DFSORT/ICETOOL job that will do what you asked for:

raam_kumar · Posted: Thu May 03, 2007 11:04 am

I think it would be better if we use
SELECT FROM(CON) TO(OUT) ON(1,3,CH) ALLDUPS

instead of

SELECT FROM(CON) TO(OUT) ON(1,3,CH) FIRSTDUP

Please correct me if i am wrong

Frank Yaeger · Posted: Thu May 03, 2007 9:23 pm

Raam,

You're wrong and you could have corrected yourself if you had just tested what you proposed.

Siva2 stated that the output should be:

ddd

With FIRSTDUP, the output is:

ddd

as requested.

With ALLDUPS, the output is:

ddd
ddd

which is NOT as requested.

In the future, I'd suggest you test your solution before posting, especially if you're going to "correct" the person who "invented" the tool (ICETOOL) being used.