TableTextCompare v1.20 - Compare csv / tab-delimited text files Copyright (c) 2011 - 2015 Nir Sofer

See Also

• CSVFileView - CSV/Tab-delimited file viewer and converter.
• NK2Edit - Edit, merge and fix the AutoComplete files of Microsoft Outlook.

Description

TableTextCompare can make the comparison even if the records of the 2 files are not sorted in the same order, or if the fields are not positioned in the same order.

Versions History

• Version 1.20:
  • Fixed bug: on some files, TableTextCompare detected added lines as modified lines.
  • Added /FastMode parameter to specify whether to use fast mode (1 = yes, 0 = no)
  • Fixed TableTextCompare to save the Fast Mode settings to the config file.
• Version 1.15:
  • Added 'Fast Mode', which works much faster if you have 2 large files the are sorted by the same field and have a small amount of differences.
• Version 1.10:
  • Added option to create a comparison report from command-line, for example:
    TableTextCompare.exe /compare "c:\temp\report1.txt" "c:\temp\filename1.txt" "c:\temp\filename2.txt" 1
• Version 1.06:
  • Fixed bug: In some cases, TableTextCompare failed to detected added/removed lines.
• Version 1.05:
  • Added 'Show Line Numbers' option. If you turn it off, the line numbers of modified/added/removed lines will not be displayed.
• Version 1.00 - First release.

System Requirements And Limitations

• This utility works on any verion of Windows, starting from Windows 2000, and up to Windows 7/2008, including x64 versions of Windows.
• This utility uses a very complex algorithm to detect the changes that have been occurred between the 2 csv/tab-delimited files. However, this algorithm is not 100% perfect, and it's possible that with very complex files and a lot of changes, the comparison report won't be 100% accurate.

What You Can Do With This Tool

• Save 2 snapshots of loaded drivers list into a tab-delimited file, by using DriverView utility, and then use TableTextCompare to find out which device drivers were added, removed, or changed since the time that the first snapshot was taken.
• Save 2 snapshots of services list into a tab-delimited file, by using ServiWin utility, and then use TableTextCompare to find out which services were added, removed, or changed since the time that the first snapshot was taken.
• If you want to compare snapshots of data from other software, and that software displays the data in a standard ListView of Windows, you can use the SysExporter utility to grab the data and export it into csv or comma-delimited file, and then you'll be able to use TableTextCompare to compare different snapshots of data.
• If you have 2 different Excel files with tables that you want to compare, you can export these tables into 2 .csv files, and then use TableTextCompare to compare the exported csv files.

General Guidelines

• When you export data from any NirSoft tool to csv/tab-delimited files, for using with TableTextCompare, it's recommended to turn on the 'Add Header Line To CSV/Tab-Delimited File' option, and then in TableTextCompare, turn on the 'First line contains the column names' option.
• Using csv/tab-delimited files with column names in the first line ensures that the comparison process will be accurate even if the columns are positioned in different order. Also, the column names will be used in the report for specifying which field has been changed.

Using TableTextCompare

After running TableTextCompare, choose or type the 2 csv/tab-delimited files that you wish to compare, and then press the 'Ok' button to get the comparison report. You can also drag the 2 files from Windows Explorer into the main window of TableTextCompare.
Be aware that if the first line of every file contains the column names ('Add Header Line To CSV/Tab-Delimited File' option in NirSoft utilities), you should check the 'First line contains the column names' option.

The comparison report contains up to 3 different sections:

• New lines found in Filename 2: This section displays all lines that exist on the second filename, but doesn't exist on the first one.
• Lines in Filename 1 that are missing on Filename 2: This section displays all lines that exist on the first filename, but doesn't exist on the second file.
• Modified lines: This section displays the difference of lines that exist in both files.

Running from command-line

For example:
TableTextCompare.exe /compare "c:\temp\report1.txt" "c:\temp\filename1.txt" "c:\temp\filename2.txt" 1
TableTextCompare.exe /FastMode 1 /compare "c:\temp\report1.txt" "c:\temp\filename1.txt" "c:\temp\filename2.txt" 0

More Command-Line Options

Comparison Report Sample

On the 'Modified lines' section, you can see the Load Count of USBD.SYS has been changed from 5 (in the first file) to 2 (in the second file)
Also, for USBSTOR.SYS - the address has been changed from 0xF5E8C000 to 0xF794E000, and the index from 136 to 139.

Text File Comparison Report
Created by using TableTextCompare
http://www.nirsoft.net/utils/csv_file_comparison.html

Filename 1:  Z:\Temp\Samples\driverview.csv
Filename 2:  Z:\Temp\Samples\driverview3.csv


Filename 1 generated on 17/07/2011 14:14:49, and contains 143 lines with 14 fields on each line.
Filename 2 generated on 30/07/2011 23:41:13, and contains 143 lines with 15 fields on each line.

New lines found in Filename 2:
Line 29:  Dbgv.sys,0xA89A2000,0xA89A6000,0x00004000,1,Unknown,136,,,,,N/A,N/A,F:\WINDOWS\system32\Drivers\Dbgv.sys
Line 39:  NirSoftOpenedFilesDriver.sys,0xF784E000,0xF7853000,0x00005000,1,Unknown,138,,,,,N/A,N/A,F:\WINDOWS\system32\drivers\NirSoftOpenedFilesDriver.sys
Line 69:  PROCMON20.SYS,0xA7884000,0xA788F000,0x0000b000,1,Unknown,140,,,,,N/A,N/A,F:\WINDOWS\system32\Drivers\PROCMON20.SYS

Lines in Filename 1 that are missing on Filename 2:
Line 139:  usbccgp.sys,0xF784E000,0x00008000,1,137,Dynamic Link Library,USB Common Class Generic Parent Driver,5.1.2600.2180 (xpsp_sp2_rtm.040803-2158),Microsoft Corporation,Microsoft� Windows� Operating System,03/08/2004 23:08:48,16/08/2008 10:49:25,F:\WINDOWS\system32\DRIVERS\usbccgp.sys,A
Line 140:  usbprint.sys,0xF5E4C000,0x00007000,1,138,Dynamic Link Library,USB Printer driver,5.1.2600.2180 (xpsp_sp2_rtm.040803-2158),Microsoft Corporation,Microsoft� Windows� Operating System,03/08/2004 23:01:26,16/08/2008 10:49:28,F:\WINDOWS\system32\DRIVERS\usbprint.sys,A
Line 141:  BrScnUsb.sys,0xA83B4000,0x00004000,1,139,Driver,Brother USB Scanner Driver,1,0,2,1,Brother Industries Ltd.,Brother MFC Scanner,15/10/2004 12:50:20,16/08/2008 10:48:45,F:\WINDOWS\system32\DRIVERS\BrScnUsb.sys,A

Modified lines:

Line 78:  USBD.SYS,0xF7AC4000,0x00002000,5,76,Dynamic Link Library,Universal Serial Bus Driver,5.1.2600.0 (XPClient.010817-1148),Microsoft Corporation,Microsoft� Windows� Operating System,04/08/2004 03:07:00,04/08/2004 03:07:00,F:\WINDOWS\system32\DRIVERS\USBD.SYS,A
Load Count:  5 => 2


Line 138:  USBSTOR.SYS,0xF5E8C000,0x00007000,1,136,Dynamic Link Library,USB Mass Storage Class Driver,5.1.2600.2180 (xpsp_sp2_rtm.040803-2158),Microsoft Corporation,Microsoft� Windows� Operating System,03/08/2004 23:08:48,03/04/2007 15:17:22,F:\WINDOWS\system32\DRIVERS\USBSTOR.SYS,A
Address:  0xF5E8C000 => 0xF794E000
Index:  136 => 139


Line 142:  kmixer.sys,0xA7DB4000,0x0002a000,1,140,Dynamic Link Library,Kernel Mode Audio Mixer,5.1.2600.2180 (xpsp_sp2_rtm.040803-2158),Microsoft Corporation,Microsoft� Windows� Operating System,03/08/2004 23:07:50,02/04/2007 01:10:06,F:\WINDOWS\system32\drivers\kmixer.sys,A
Address:  0xA7DB4000 => 0xA6B54000
Index:  140 => 138


Line 143:  ntdll.dll,0x7C900000,0x000b0000,1,141,Dynamic Link Library,NT Layer DLL,5.1.2600.2180 (xpsp_sp2_rtm.040803-2158),Microsoft Corporation,Microsoft� Windows� Operating System,04/08/2004 03:07:00,04/08/2004 03:07:00,F:\WINDOWS\system32\ntdll.dll,A
Index:  141 => 139

Translating TableTextCompare to other languages

1. Run TableTextCompare with /savelangfile parameter:
   TableTextCompare.exe /savelangfile
   A file named TableTextCompare_lng.ini will be created in the folder of TableTextCompare utility.
2. Open the created language file in Notepad or in any other text editor.
3. Translate all string entries to the desired language. Optionally, you can also add your name and/or a link to your Web site. (TranslatorName and TranslatorURL values) If you add this information, it'll be used in the 'About' window.
4. After you finish the translation, Run TableTextCompare, and all translated strings will be loaded from the language file.
   If you want to run TableTextCompare without the translation, simply rename the language file, or move it to another folder.

License

Disclaimer

Feedback

Download TableTextCompare

TableTextCompare is also available in other languages. In order to change the language of TableTextCompare, download the appropriate language zip file, extract the 'tabletextcompare_lng.ini', and put it in the same folder that you Installed TableTextCompare utility.

Language	Translated By	Date	Version
Arabic	Mustafa A Alesayi	05/08/2011	1.00
Dutch	Jan Verheijen	29/05/2015	1.20
French	Largo	21/08/2018	1.20
German	«Latino» auf WinTotal.de	26/05/2015	1.20
Greek	geogeo.gr	10/07/2014	1.15
Hungarian	Timinoun	12/12/2022	1.20
Persian	DinoTechno	30/03/2022	1.20
Polish	Hightower	13/07/2014	1.15
Romanian	Jaff (Oprea Nicolae)	05/02/2016	1.20
Russian	Dmitry Yerokhin	09/07/2014	1.15
Simplified Chinese	德雅全球购	28/12/2019	1.20
Slovak	František Fico	09/02/2017	1.20
Spanish	Ricardo A. Rivas	12/07/2020	1.20
Traditional Chinese	ivangundampc	12/08/2013	1.10
Turkish	Cemil Kaynar	28/03/2017	1.20
Turkish	HARUN ARI	04/08/2011	1.00