Informatica replace multiple spaces with single space.

Posted: March 1, 2016 in Informatica

Ex:- REG_REPLACE(Column, ‘\s+’, ‘ ’)

Like Function in Informatica:-

What is the equivalent expression for

case when CNTRY_NM like ‘%IND%’ the ‘India’ when CNTRY_NM like ‘%USA%’ then ‘USA’ end as CNTRY_NM

IIF(REG_MATCH(UPPER(CNTRY_NM),’.*IND.*’)=1,’India’,
IIF(REG_MATCH(UPPER(CNTRY_NM),’.*USA.*’)=1,’USA’,CNTRY_NM))

Note:- Make sure to use UPPER case on both side’s

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s