Easy way to filter carriage returns with Powercenter

Being lazy, today I used a filter expression in Powercenter to filter carriage return / line feeds from source text files when loading source data to ETL staging tables. And it works quite well! It’s just a manner of adding the following filter:

 

 The expression itself is:

<first attribute of line> != ‘’

It really worked quite well and it saved us from using all kinds of scripts to clean up the file before processing. And more importantly the source file has been preserved for archiving.

 
Roelant Vos

Roelant Vos

You may also like...

2 Responses

  1. des says:

    Informatica now has regex that can do the job too 🙂

     

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.