Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
Quote:
i want to sort the file those records in both files in one output file and those belong to individuals in the other output file....
If I m not mistaking, U r looking for two o/p files.
One having all the values from File 1, which are also there in File 2.
Second having all the recs from both files which are not in the other file.
This will give you Not duplicate values. Replacing NODUPS in the code with ALLDUPS will give you duplicate values. Also change "L" in the code to the field value of yours (1 in your given example).