Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Find records that changed during validation

Validate your database with the Preserve Original Address box checked

Pull down the Edit menu to Command and run this command:

Replace x with "X" FOR !ALLT(UPPER(oaddress))==ALLT(UPPER(address))

Click Run, then close the Command window.

Pull down the File menu and choose Export.

Choose the fields you’d like to export.

Click on Marked in the scope area.

Choose your export format.

Click Export.

Give the file a name, choose a location to save it, then click Save.

« Back to Tech Notes

I understand why the USPS needs to change things over time, but since they don't have to deal with customers' software they often don't care about the downstream effects. You guys do a great job on both fronts.
J.P., Greenville, NC