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: Remove Carriage Return

Free download

Posted by: Informatica Professional Services

Mapping to remove carriage return, line feed and special characters from given string using data quality transformation.



Informatica Data Quality provides out-of-box transformation to standardize address and contact information. String data may contain new line and special characters that need to be removed before further processing.


This solution provides a re-usable rule that performs the function using a labeler and standardizer.


The list of characters that will be removed apart from carriage return and line feed.



  • PowerCenter version 9.1 and above


Comments Comments (2)