Replace Function

[mtechnocrat]

Hi

From source data one column is coming with carraige returns , in target table i have to replace this carriage return with spaces .is there any function like REPLACE in oracle ? Can guide me in this issue

Thanks

[Sainath.Srinivasan]

This post has been answered in the server forum.

[xcb]

Try using Convert or EReplace. These two functions are almost identical except Convert replaces on a character by character substitution where as EReplace replaces whole substrings. Look at your Datastage Basic pdf manual for the complete definition of these two functions.

[chulett]

Please don't post the same question in both forums unless you are specifically looking for both a Server and a PX answer. This forum is meant for questions on the EE/PX product where the answer to your question would be:

a) Totally different and
b) Unusable in a Server job

Thanks.