ExamDiff Pro 13.0: Improved Table Comparison
If you're a regular reader of our blog, you'll recall that you can already compare tabular data in ExamDiff Pro, by using a custom plugin to sort columns and the Ignore Column Ranges option to ignore unwanted columns.
ExamDiff Pro 13.0 builds on this functionality and introduces a brand-new Table Comparison mode, with built-in functionality to sort and ignore columns and the ability to differentiate columns by color to better view tabular data.
Let's try it out, using the same CSV files as in the previous blog post on table comparison.
Comparing these files as plain-old text files with no special options gives us the same mess that we ran into last time:
Actually, before we do that, let's set the table comparison options that we need. We want to sort these files by their first column (
BusinessEntityID) and ignore the 5th column (
ModifiedDate). So, we go to the new Table Comparison options panel and enable Sort Columns for column 1 and Ignore Columns for column 5:
What's more, we aren't limited to comma-separated files anymore! By default, Table Comparison works on CSV (comma-separated) and TSV (tab-separated) files, but you can define any tabular file type with any delimiters that you want, in the Table file types section of the Table Comparison options panel: