Data Cleansing Publisher's description
Data Cleansing is a handy application designed to help you modify multiple values from a MySQL database. The program can connect to a specified database and filter the database entries in or.
Data Cleansing is a utility to clean up the field values in a MySQL database. 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.
What's New in This Release:Compatible with MacOS X Mountain Lion.
Added the ability to clean one field based on the value in another field
Added the ability to add a MySQL WHERE command. This allows you to limit what records are considered for cleansing.
Added the ability to determine the Salutation based on the First Name.
Added the ability to look up data based on a UK or USA postcode. Updates include City, State/County, Country, Region, SubRegion, Latitude and Longitude.
Program is freely downloadable from the web site and came be run twice before needing a purchase.
System Requirements:No special requirements.
Program Release Status: New Release
Program Install Support: Install and Uninstall