Data Cleansing

Perform Data Cleansing on any MySQL database. Clean your Text, Number and Date field values with 50 different cleansing types. Preview your changes before they are made. See the original and the cleaned values side-by-side. Make last minute edits or remove certain records from updating. Save the preview changes to a spreadsheet, CSV or tab-delimited file. Copy the changes to the clipboard for pasting elsewhere. Many of the cleansing types have options to tailor your specific changes. View the Wikipedia page on data cleansing directly in the app. When you are ready update the changes directly into the database. Cleansing types include: iNVERT cASE lowercase RaNdOM cAsE Title Case Sentence case UPPERCASE Add Time to Date Bullets to Hyphens Date Format Day of the Week Day of the Year Days left in the Year Em/En-dash to Hyphen Hash Value Hyphen to Em-dash Hyphen to En-dash L33T Speak LineFeeds to Returns Non-breaking Spaces to normal Space Normal Spaces to non-breaking Space Number Format Number of Letters Number of Words Number to Words “Quotes” Returns to LineFeeds Shift ASCII value Soundex Code Symbols Tabs to Spaces Value Week of the Year Remove All Remove All ASCII Remove ASCII Control characters Remove Excess Returns Remove Excess Spaces Remove Excess Tabs Remove LineFeeds Remove Non ASCII Remove Non Letters Remove Non Numbers Remove Periods Remove Punctuation Remove Returns Remove Spaces Remove Tabs Email to Web Name to Salutation/First/Last Phone Number