Post by terry on Oct 2, 2014 10:01:02 GMT -5
My first macro effort.
Sometimes, one might want to know what the value of duplicate lines might be in a file rather than simply using DELETE DUP of SORT UNIQ to eliminate them. In a large file, this can be difficult and tedious.
This macro will step through a pre-sorted file and create a file EXTDUPS.TXT containing the duplicate lines. Unlike DELETE DUP, a start column and end column can be used as arguments to limit the compare to specific columns in each line.
Any suggestions for improvement would be appreciated. I toyed with the idea of copying the output buffer to the clipboard followed by issuing SPF_CMD("CLIP") in the hope that it would open a new tab containing the duplicate lines, but it doesn't seem to work.
Cheers,
Terry
UPDATE: 10/03/2014
Added numeric verification of the column arguments.
Duplicates are also saved to the Windows clipboard. Issue CLIP command to view them after macro completes.
UPDATE: 10/04/2014
Added 3rd optional argument which allows user to specify whether to store duplicates in a file or Windows clipboard (Default).
Added additional documentation.
ExtDups.macro (6.89 KB)
Sometimes, one might want to know what the value of duplicate lines might be in a file rather than simply using DELETE DUP of SORT UNIQ to eliminate them. In a large file, this can be difficult and tedious.
This macro will step through a pre-sorted file and create a file EXTDUPS.TXT containing the duplicate lines. Unlike DELETE DUP, a start column and end column can be used as arguments to limit the compare to specific columns in each line.
Any suggestions for improvement would be appreciated. I toyed with the idea of copying the output buffer to the clipboard followed by issuing SPF_CMD("CLIP") in the hope that it would open a new tab containing the duplicate lines, but it doesn't seem to work.
Cheers,
Terry
UPDATE: 10/03/2014
Added numeric verification of the column arguments.
Duplicates are also saved to the Windows clipboard. Issue CLIP command to view them after macro completes.
UPDATE: 10/04/2014
Added 3rd optional argument which allows user to specify whether to store duplicates in a file or Windows clipboard (Default).
Added additional documentation.
ExtDups.macro (6.89 KB)
