Project LID Homepage: Distributable Modules
LCCFindDuplicates Homepage
Updates

Update 8/12/2019: Upgrade: better support of varied columns lengths, empty records. Style/layout design upgrades.

Update 4/17/2019: Upgrade: handle records with more columns than the first record

Update 4/4/2019: Upgrade: handle records with inconsistent # of columns

Update 10/26/2017: Upgrade: handle records with extended characters in value, like ASCII code 10

Update 8/24/2017: Upgrade: added minimum duplicates to find

Update 4/25/2017: Upgrade: more verbose error message and record reference on record issues. Allow rerun after issue, without closing.

Update 4/19/2017: Upgrade: handling of different delimiters when surrounds by double quotes.

Update 3/10/2017: Bug fix: when records do not contain any of the delimiter specified.

Update 8/18/2014: Program released.

Description

lccFindDuplicates is a Windows program to help find duplicate records, using specific columns, but, returning the entire records.

Others LCC tools suggested for this type of need:

Records (file) can be pre-sorted, or sorted within the program.

For example, you could compare the Birthdate and Name of a person, and return all records that have the same Birthdate/LastName as another record.

Installation Documentation Screenshot
Disclaimer
The programs, scripts and documentation are provided AS IS without warranty of any kind. Lower Columbia College further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the programs, scripts and documentation remains with you. In no event shall Lower Columbia College, its authors, or anyone else involved in the creation, production, or delivery of the programs, scripts or documentation be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the programs, scripts or documentation, even if Lower Columbia College has been advised of the possibility of such damages.