How-to Guide

“Hell is other people’s data.” —Jim Harris 1

• Install Datatest
• Get Started Testing
• Run Tests
• Column Names
• Customize Differences
• Data Types
• Date and Time Strings
• Date and Time Objects
• File Names
• Test File Properties
• Excel Auto-Formatting
• Mailing Addresses
• Fuzzy Matching
• NaN Values
• Negative Matches
• Outliers
• Phone Numbers
• Re-order Acceptances
• Sequences

1

Harris, Jim. “Hell is other people’s data”, OCDQ (blog), August 06, 2010, Retrieved from http://www.ocdqblog.com/home/hell-is-other-peoples-data.html