LCCCompareCombine Homepage

Project LID Homepage: Distributable Modules

Updates

Upgraded 3/26/2019: Manual update: added keys 'lcc:debugMasterFileFilter', 'lcc:debugCompareToFileFilter'. Bug fix: incorrect indexing on non-sorted files, i.e. some records would be skipped.

Upgraded 7/19/2018: Manual update: added note to lcc:firstColSorted key.

Upgraded 5/2/2018: Upgrade: Added key 'lcc:startAtLastMatch'. Changed key ' lcc:displayHundredRecordCounter' to 'lcc:displayRecordCounter'.

Upgraded 4/19/2017: Upgrade: Added key 'lcc:displayHundredRecordCounter'.

Upgraded 8/16/2017: Bug fixed: when master record has no match in compare file, left over values were being used on the combine keys.

Upgraded 4/19/2017: Upgrade: handling of delimiter within values within double quotes.

Upgraded 4/18/2017: Added keys 'lcc:outputFileAppend', 'lcc:outputFilePrePendDateTime', 'lcc:unmatchedFileAppend', 'lcc:unmatchedFilePrePendDateTime'.

Upgraded 3/10/2017: Added key 'lcc:debugMode'.

Upgraded 2/23/2017: Added keys 'lcc:multipleMatches', 'lcc:multipleMatchesFilePath', 'lcc:multipleMatchesFileDelimiter'.

Upgraded 2/17/2017: Added key 'lcc:compareRule'.

Upgraded 2/14/2017: Added key 'lcc:unmatchedFileDelimiter'.

Update 12/6/2016: Bug fixed: when supplying a non-standard column delimiter (i.e. other than comma or tab), unmatched column not written.

Update 10/17/2016: Upgrade: made key 'lcc:unmatchedFilePath' optional. Changed some erratas in the manual.

Update 2/3/2016: Upgraded to .NET 4

Update 1/22/2016: Upgraded program to handle CSV files containing commas and/or double quotes in columns

Update 05/08/2015: Added lcc:sort.

Update 03/05/2014: Added lcc:firstColSorted.

Update 06/14/2013: Added lcc:masterFileKeepUnmatched.

Update 06/07/2013: Code Released

Description

The lccCompareCombine was developed to Compare the records in one file (the master) to another file (compare to) on column matches between the two.

Others LCC tools suggested for this type of need:

lccColumnsCruncher (Command Line)
lccFindDuplicates (Windows)
lccParseColumns (Windows)

On records that match, a Combine option allows the combining of columns both one or both of the files into a combined file.

Unmatched records from the master will be copied into an unmatched file.

Another program with many more rule types was developed later, though this one is great for simple column comparisons against small to very large files. Please see lccColumnsCruncher

Documents

lccCompareCombine Manual
Example Logic File 1: compare of two columns
Example Logic File 2: compare two columns, with the second having to be mismatched
Example Logic File 3: compare to large lists and move the pointing as matches are found

Application Files

lccCompareCombine-installation.zip

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.