Database Cleaner 1.2
- LICENSE TYPE:
- FILE SIZE:
- 687 KB
- OUR RATING:
- DEVELOPED BY:
- USER RATING:
- C: \ Internet \ Servers \ Database Utils
Simple yet practical user interface
The main window of the application is very user-friendly and intuitive, making it quite handy, both for experienced individuals and novices, as it requires a minimal level of effort in working with it. All of the relevant functions are featured in Database Cleaner’s ribbon, for quick access.
It allows you to import the database file you wish to work with, supporting several formats, namely XLS, XLSX, TXT/CSV, MDB, ACCDB, Microsoft SQL or MySQL, the last two requiring you to authenticate and connect to the server.
Load your database file and start removing duplicates
To begin, you can import the file that you wish to clean by means of the ‘Open Table’ function, choosing the preferred visualization options, then loading the data in the main window of Database Cleaner. The ‘Statistics’ tab can be used for a graph-visualization of the ‘Empty’ or ‘Populated’ fields, being able to focus on specific types of records.
The ‘Find Duplicates’ component enables you to look for an ‘Exact Match’ or a ‘SoundEx Match’, specifying the type of the targeted ‘Column Name’, then pressing the ‘Start Search’ button. The detected redundant entries can be deleted with a few mouse moves.
Using the ‘Match Second List’ feature, you can import ‘Non-Matching Records’ into Database Cleaner, adding the corresponding items to your current file. Other tools include the ‘Email Cleaner’, ‘Text Cleaner’ and ‘Case Cleaner’.
Duplicate removing utility
To sum it up, Database Cleaner is a straight-forward and efficient program whose main purpose is to help you erase duplicates from your database files, without the slightest effort, being rather handy for marketing professionals, retail businesses, banking or schooling systems, as well as countless other situations.
Database Cleaner was reviewed by Marina Dan, last updated on March 31st, 2014
Runs on: Windows 2K / XP / Vista / Vista 64 bit / 7 / 7 64 bit / 8 / 8 64 bit