Oracle replace and translate command in IICS

200 Views Asked by At

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

1

There are 1 best solutions below

0
On

Try using the REG_REPLACE function. I'm not sure if this will work simply as:

REG_REPLACE( HDDJD_DG, '²¿àçéèîÀÇɵ', '')

or if you'd need to trim after replace:

LTRIM(RTRIM(REG_REPLACE( HDDJD_DG, '²¿àçéèîÀÇɵ', '')))