Clean, Standardize, and Reformat Any Data Type

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 the Melissa Cleanser transform 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 - How Cleanser Works

How Cleanser Works

The Cleanser transform 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. The transform has five main cleansing operations:

View Cleansing Options

  • 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.

Ready to Get Started?

Let’s Talk

Improve the quality of your customer data today.

Contact us
Explore the API

Discover Melissa APIs, sample code & documentation.

Learn more
Try Listware

Use our Online data cleansing app or plugin for Excel.

Start for free
Use our Service Bureau

Full-service data processing to clean, dedupe & enrich.

Send us your file

Helpful Resources


Data Cleansing Video

Watch Video
Ready to Start Your Demo?

Start today with Melissa's wide range of Data Quality Solutions, Tools, and Support.

Schedule a Demo