Duplicates

dweddle · Post by **dweddle** » Mon Aug 29, 2011 10:29 am

Is there a tool or macro that can check text document for duplicate entries so extras can be deleted?

ak47wong · Post by **ak47wong** » Mon Aug 29, 2011 11:19 am

You can remove duplicate entries when sorting the lines in a document. Click Tools > Sort and select Delete duplicate lines.

SteveH · Post by **SteveH** » Mon Aug 29, 2011 11:24 am

As far as I know there's not a tool that does specifically what you are after.

If your file is structured lines of data you might be able to sort the file and delete duplicate lines at that point.

It's not perfect though because there's no way to get back the original order from there.

If you have any examples showing the the text files you have, that may be useful.