Melissa - Global Intelligence  1-800-MELISSA

Generalized Cleansing

Data Cleansing

Clean, Standardize, and Reformat Any Data Type

Let's Start A New Project Together

Generalized Cleansing

In the era of big data, data stewards spend a large amount of time doing “data janitor” work – the time-consuming, mundane task of collecting, preparing, and cleaning disparate data. We offer a Generalized Cleansing component for Pentaho® and Microsoft SQL Server® Integration Services (SSIS) to help automate and prepare data for the cleansing process. This empowers users to build custom data cleansing scripts for data suffering from a wide range of errors and inconsistencies. With the component, data stewards have the ability to standardize and validate inventory lists to better prep and cleanse data prior to analysis.

  • Cleanse any type of data and achieve a higher standard of data quality for integration, warehousing, and analytics
  • Gain greater control of your data when optimized, and save your business time and resources
  • Customize and create rules (triggering) to standardize data
Data Cleansing - Clean, Standardize, and Reformat Any Data Type

Ways to Access Generalized Cleansing

Generalized Cleansing - Integrations and Plugins

Integrations and Plugins

Clean address data directly in popular programs including:


Let's Start A New Project Together

How it Works

The Generalized Cleansing component enables users to clean, standardize, and reformat any data type – from changing casing or capitalization, adding or removing punctuation, expanding or contracting abbreviations, and searching and replacing any parts of a string. The tool applies different cleansing operations to your data integration and warehousing efforts. Our component has six main cleansing operations:

  • Punctuation
    Add or remove punctuation.

  • Abbreviation
    Expand or contract abbreviations, for example: CA to California

  • Search & Replace
    Replace portions of a string

  • Expressions
    Create programmatic expressions to make sense of data values

  • Regex
    Use regular expressions to extract, validate, etc.

Melissa's Demographic Data File Appends Vital Consumer Data Elements.

What Our Customers Say


Data Sheets

Free Trial & ROI Guarantee

Request a free trial by filling out the form.

  •   30-day free trial so you can test our tools in your environment.

  •   Free, unlimited technical support.

  •   120-Day ROI Guarantee!

Let's Start A New Project Together