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 Add Punctuation Space

Free download

Posted by: Informatica Data Quality Unit

Download Data Quality rules that help you to add space around the string based on special characters.

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.

 

Adding space to string rules is part of the Data Quality core accelerators available with Informatica Data Quality Product. In this example we are adding the Space around the String if it contains special characters like Ampersand, hyphen, Between Number and Letter and Period for formatting input data. To achieve this we are making use of following rules comes with the installation of Core Accelerators.

 

NameDescription
rule_Add_Space_Around_AmpersandAdds a space before and after all ampersands in a string.
rule_Add_Space_Around_HyphenParses a number that occurs at the end of a string, reading from left to right.
rule_Add_Space_Between_Number_LetterAdds a space in between a character pair composed of one numeral and One alphabetic character. Reading from left to right, this mapplet adds a space to the first numeral-alphabetic character pair in the data.
rule_Add_Spaces_Around_PeriodAdds a space before and after all periods in a string.

Specifications

  • Informatica Data Quality 9.5.1
Comments Comments (0)

Related