Save Orphans to Spreadsheet

[rdclk23]

Here is a trick I use to create a file of orphan records from BC3 (exist in one file but not the other). Do a Data compare in BC3 and show just the desired orphan records (left or right side). Then from the Session menu, create a Data Compare report, side by side, HTML format, Save as file. Open the html file in Excel and delete out the empty columns (left or right side). Delete out the extra headings and leave just the column names. Save the file as .csv or desired file format.

[Aaron]

Thanks for posting this tip. I'm sure some of the community will find it very useful.

[kengrubb]

This might result in fewer conversion hops

If it's data for which you want only exact matches be sure to first do this:
Session, Session Settings, Alignment tab, Check "Never align differences"

Then:
Check Show Differences, Uncheck Show Context

Click in the Left Panel
CTRL-A (Select All)
CTRL-C (Copy)
Paste into your favorite editor or spreadsheet

Click in the Right Panel
CTRL-A (Select All)
CTRL-C (Copy)
Paste into your favorite editor or spreadsheet

If you want the Left and Right Orphan list comingled, your favorite editor or spreadsheet program should be able to sort them and even eliminate duplicates, if any exist, with the click of a few buttons. I'm a TextPad junkie, but I'm sure there are equally additive and useful freebies.