|I have 2 files of several thousand CDs. The first has everything listed (about 5,000 lines), the second has several thousand titles less (about 3,500 lines - basically, the ones I have sold).|
I have merged the two files to create a file where the unsold items are duplicated. What I am trying to do is create a 'sold' file, containing ONLY the lines that are are NOT duplicated. In other words, where the lines are duplicated, I need to remove BOTH duplicated lines.
In other words, I want the end result to be the approx. 1,500 lines that are in the first file, but not the second.
Any idea how I can do this.