retriew duplicates from input file

[ss123mercator]

Hi,

Could anybody help me,how to retriew only duplicates from an input file.output file has to show only duplicates.
ex:input file output file
a b c a b c
b g f a b c
s d f b g f
w d b b g f
a b c
b g f

Thanks.

 

[nelfel]

svrrp,

Is the input file indexed (as in SQL Server)? If so, you can do this with a SQL statement in the Query of the .mdq file or a stored procedure. Let me know.

nelfel

 

[ss123mercator]

Thanks nelfel, I want it with map rules not from database. I did it and I got output.

Thanks once again for u r response.

 

[PaulBrett]

I have an example that if provided with a list of NL seperated objects will print a list of only those objects that appear more than once, and the number of times that they appear.

Please email customercare.uk@mercator.com for the example.