DSXchange

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

This post has been answered in the server forum.

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.

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.