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.
Informatica now has regex that can do the job too 🙂
Hi Desmond! Do you know with what code? I was never a hero with regular expressions 🙂