I need to translate these oracle command into Informatica (IICS).
Please could you tell me how to do?
Regards
replace(translate(HDDJD_DG,'²¿àçéèîÀÇɵ',' '),' ','')
and the last one
cast('RAP' as varchar2(3))
Thanks for your help
I need to translate these oracle command into Informatica (IICS).
Please could you tell me how to do?
Regards
replace(translate(HDDJD_DG,'²¿àçéèîÀÇɵ',' '),' ','')
and the last one
cast('RAP' as varchar2(3))
Thanks for your help
Copyright © 2021 Jogjafile Inc.
Try using the REG_REPLACE function. I'm not sure if this will work simply as:
or if you'd need to trim after replace: