Youtube Linkedin Link Calendar-alt
Login/Register
Register Login

Data Cleansing

Table of Content

MDP Resource Center
MDP Cleansing and Standardization

Video Guide

Basic Cleansing Functions

1- Remove Tab

  • Use this to eliminate unwanted characters:
  • Leading/trailing spaces – one of the most common issues
  • Spaces, punctuation, and letters – helpful for cleaning phone numbers
  • Defined prefixes – remove known patterns like country codes
  • After setting your preferences, click Save and Add to include the rule in your task list.

2. Replace Tab

  • Identify common tokens using tokenization, then:
  • Define lookup text (e.g., &)
  • Set replacement text (e.g., and)
  • Optional: check case sensitivity
  • Useful for standardizing names, company abbreviations, and symbols.

3. Copy Column

  • Duplicate a column for backup or tracking
  • Useful for comparing original and cleansed values side by side

4. Case Options

  • Convert to Uppercase, Lowercase, or Proper Case
  • Example: Fix inconsistent city names with Proper Case
  • Click graph to filter by valid/invalid
  • See issues like illegal characters

5. Fill Blanks

  • Fill null/empty values with a static default (e.g., No Email)
  • Refer to profile data to identify columns with blanks
  • Click graph to filter by valid/invalid
  • See issues like illegal characters

Advanced Cleansing Functions

1. Conditional Function

  • Apply logic-based transformations:
  • Create outputs based on a condition (e.g., text contains SUP → label as Supplier)
  • Use with string operations or missing values
  • Output new column with dynamic value based on the condition
  • Example: Create a column Contact Type based on pattern in Account Code

2. Mathematical Functions

  • Perform arithmetic operations on numeric columns:
  • Sum: Add multiple columns
  • Difference: Subtract one from another
  • Multiply: Product of two or more columns
  • Divide: Define dividend and divisor
  • Average: Mean of selected values

3. Merge Function

  • Combine columns into a new column:
  • Add delimiter (e.g., hyphen or space)
  • Use Merge Only Non-Blank Values to avoid empty delimiters
  • Use First Not Empty to return the first available non-null value
  • Example: Merge First Name and Last Name into Full Name

4. Split Function

  • Split column values based on delimiter:
  • Define delimiter (e.g., @ for emails)
  • Set a prefix for resulting columns
  • Useful for separating usernames/domains

5. Left/Right Function

  • Extract or exclude characters:
  • Left: Keep the first N characters
  • Right: Keep the last N characters
  • Exclude Left/Right: Remove first or last N characters
  • Example: Trim zip codes, remove prefixes, or extract phone digits

6. Search Function

  • Search for a substring:
  • Returns True or False
  • Define search term (e.g., "gmail")
  • Output a new column with result

7. Dynamic String Function

  • Build formatted strings using static text and column values:
  • Combine values into a JSON-style output or custom label
  • Useful for templated fields and exports

8. Data Conversion Function

  • Change date formatting:
  • Choose from predefined formats
  • Useful for preparing data for system imports or reports
  • Profile data is accessible without leaving your current screen

Summary

  • The cleansing module allows:
  • Quick cleanup of messy data
  • Logic-driven column transformations
  • Math operations and merging for calculated fields
  • Format conversions for compatibility and standardization
  • Use these features to improve your dataset quality and prepare it for confident matching.

Match Data Pro — An easier way to clean, match, and merge data.

FAQs

After logging in, navigate to your user profile settings where you can:

  • Change your password

  • Update your name and billing information

  • Add a phone number for multi-factor authentication

  • Set your default language

  • Configure your time zone, which is used across all timestamps in the tool

A free/test account allows you to process up to 1,000 records per project. To handle larger datasets, you’ll need to upgrade to a paid subscription.

Match Data Pro offers several UI customization options:

  • Adjust layout, menu style, text direction, and flow

  • Switch between light and dark modes

  • Change interface language

  • Toggle fullscreen mode

  • Receive and view notifications

You can enable notifications to alert you when processes begin or finish. Additionally, there’s a Live Chat feature at the bottom of the screen to connect with support anytime.

From the dashboard, click on the “New Project” button. You’ll be guided through the process of naming your project, selecting modules, and configuring settings.

Payments for subscriptions can be made via PayPal or Stripe (credit card).

You can reach out to the Match Data Pro support team through the Live Chat feature on the platform or by emailing support@matchdatapro.com.

Start Your First Project

To begin, click the New Project button from the dashboard.

Let's Start
Back to Home
Next: Profiling
Match Data Pro

At Match Data Pro, our core focus is fuzzy data matching and entity resolution but our platform goes far beyond that

Youtube Linkedin Link Calendar-alt
Quick Links
Contact Us

+1 (302)450-1978

sales@matchdatapro.com

Address: 1041 N Dupont Hwy #1713 Dover, DE 19901

Subscribe to Our Newsletter

Subscribe to our newsletter for the latest updates, insider news, special offers, and more regarding fuzzy data matching.

Copyright 2025 Match Data Pro. All Rights Reserved

Privacy Policy | Data Security and Certifications