Data Match 2010 - Clean

Clean your data across all tables at the same time

• Apply cleaning across all tables, or just the tables/fields you select.
• Preview the effect the cleaning options have on your data in the dynamic data window.
• Change case including Proper casing (i.e. change "john smith"to "John Smith") Improving the professional appearance of your data.
• Remove non printeable characters that can cause problems, like carriage returns, page breaks, etc.
• Eliminate spacing issues by removing trailing or leading spaces.
• Remove specific characters like ?@#$%