Using REG_MATCH and REG_REPLACE function in Informatica to replace a Prefix and suffix of a character
I have a Business requirement in infromatica where we have 2 set of Data’s like
‘HOUSE ACCOUNT – WELLS FARGO – I’ where we
have to remove the suffix ‘ – I ‘ and another Data
‘JR INSURANCE BROKERAGE INC’ where I have to remove the prefix ‘JR’
currently I am Using the following code and its not working