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
IIF(REG_MATCH(LAST_NAME,'.*sIs.*') OR REG_MATCH(LAST_NAME,'.*sI'),REG_REPLACE(LAST_NAME,'I$','')
IIF(REG_MATCH(LAST_NAME,'.*sJRs.*') OR REG_MATCH(LAST_NAME,'.*sJR'),REPLACESTR(1,LAST_NAME,'JR','')
Can you Please help me on this ?
11
This is related to your previous question. Please try to break this down and do some proper testing.
- Build a transformation with
REG_MATCH(LAST_NAME, 'YOUR-CODE-HERE') - Test the results
- Add another, separate port with
REG_REPLACE(LAST_NAME,'YOUR-CODE-HERE','') - Test it.
- Once you’re satisfied with the results, pull it all together in one expression
- Test it.
If at any point you’re stuck, please provide your code, test ressults and question. We’re happy to assist. However please do not expect the members of this community to write the code for you.
Best of luck with your efforts!