Feature Highlights
|
|
|
|
| Import / Export any kind of list, using common data types including Excel, Access, text files, DBF files & SQL Server, including Office 2007. |
|
|
|
| Import / Export contacts directly from MS Outlook |
|
|
|
| Manipulate your data with a variety of functions: view, edit, cut/copy/paste, sort, filter. |
|
|
|
| Case Converter Module for automatically standardizing name and address details. |
|
|
|
| Column Cleaner Module which groups together and counts common values in a column to help identify duplicates or discrepancies. |
|
|
|
| Text Cleaner Module for removing non-printable and unwanted characters, leading or trailing spaces and much more for ensuring clean and accurate data. |
|
|
|
| Email Cleaner Module for managing and identifying inaccurate email addresses from your lists. |
|
|
|
| Basic Deduplication - find identical matches, without the need for fuzzy matching or fancy algorithms. |
|
|
|
| Statistics Module for identifying missing data with scoring system and charts (2D & 3D charting). |
|
|
|
| Email Analysis Engine (EAE), for suggesting correct email addresses from your list of bad emails. |
|
|
|
| Customized Prefixes & Exceptions editor for case conversion (Ibm = IBM, Mclaren = McLaren, etc). |
|
|
|
| Advanced Data Filtering. Allows you to perform and customize quick ways to filter out bad data. |
|
|
|
| Import two separate files. |
|
|
|
| Ability to match two separate lists against each other. |
|
|
|
| Advanced Persons Name Deduplication - (Bob Smith = Robert Smith, Dave Evens = David Evens, etc) |
|
|
|
| Advanced Address Deduplication - (150 Park Street = 150 Park Str, 25 Queens Road = 150 Queens Rd, etc). |
|
|
|
| Advanced Company Names Deduplication (Flowers Limited = Flowers LTD, Marketing World PLC = Marketing World, etc). |
|
|
|
| Fuzzy Matching Data Deduplication - Pattern matching of words which looks for similarities in spelling and gives a "nearness score" of each pair of records compaired. Very powerful feature that is normally only available on very expensive data deduplication software. |
|
|
|
| Fuzzy Threshold Level Setting - Set a match threshold to find the greatest number of duplications on your lists. |
|
|
|
| Advanced Telephone matching that may contain international codes, local codes or simply spaces and hashes.( +447958 12 34 56 = 0044 7958123456 = 07958 123 456) |
|
|
|
| Partial matching with option to ignore and not match any values that are blank/empty. |
|
|
|
| Cross Column Matching - search for possible duplications that have been entered into the incorrect columns - (Robert Smith = Smith Bob, etc) |
|
|
|
| Intelligent Merge/Purge. Merge duplicate records on one table or across two tables. |
|
|
|
Duel Screen Capability - allowing you to perform list cleaning and deduplication routines with the ability to also view your entire list/s, all at the same time.
|
|
|
|
Column Splitter Module - Split columns into various parts. For example a persons full name can be split into title, firstname, surname.
|
|
|
|
Column Merge Module - Joining values from two seperate columns. For example, on a list that contains the fields "Firstname" and 'Surname" with the values "John" and "Smith", this may be concatenated to give "John Smith" in a separate column
|
|
|
|
Maximum number of columns that can be imported
|
90
|
100
|
250
|
| Maximum number of records that can be imported |
100,000
|
2 x 150,000
|
Standard Edition = 2 x 250,00 Business Edition = 2 x 500,000
|
