Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Data Quality: Rules To Remove Space and Hyphen

Free download

Posted by: Informatica Data Quality Unit

Download Data Quality rules that help you to remove extra Space and Hyphen around the string. It also contains a mapping to demonstrate removing the space around the string using the rules.

Overview

Informatica provides the Core accelerator with the Content installer. The Core accelerator contains data quality rules that you can use with data from multiple regions. Core Accelerators provide solutions to common data quality issues in a country, region, or industry. Core Accelerators contain rules, reference tables, demonstration mappings, and demonstration data objects.

 

Removing the Space and Hyphen are rules which are part of the Data Quality core accelerators available with Informatica Data Quality. In this example we are remove extra space from the customer name field. To achieve this we are making use of following rules comes with installation of Core Accelerators

 

NameDescription
rule_AllTrimRemoves all leading and trailing spaces from input data.
rule_Remove_Extra_Spaces

Replaces all multiple consecutive spaces with a single space and trims

leading and trailing spaces.
rule_Remove_HyphenRemoves hyphens.

Specifications

  • Informatica Data Quality 9.5.1
Comments Comments (0)

Related