Update 3/13/2025: Upgrade: Added keys "lcc:outputFileRowHeader", "lcc :unmatchedFileRowHeader"
Update 1/23/2023: Upgrade: reports if file 1 or file 2 do not have enough column for doing a row compare.
Update 12/1/2022: Upgrade: function for parsing delimited lines expanded for more data format scenarios.
Update 10/19/2022: Update: bug fix, if using lcc:firstColSorted, was usign incorrect column #.
Update 8/29/2022: Update: if last source column is empty, still used in processing.
Upgraded 7/6/2022: Upgrade: better support for delimited columns with qualified values (i.e. value containing the delimiter).
Upgraded 2/10/2022: Upgrade: added auto sort of first column when key lcc:firstColSorted provided and is 'YES'.
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/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
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:
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