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

Search for Convert.

U can use the REPLACE function of Datastage to do this.

For convert function

Expression should be Convert("\r", " ", MyString)

For replace function

Expression should be Ereplace(MyString, "\r", " ")

thanks

You can also use Char(10) in place of the \r.

REPLACE is similar to CHANGE or EREPLACE.

Nah!

REPLACE replaces the value of an element in a dynamic array.

You need to use CONVERT, EREPLACE or CHANGE. CHANGE is a subset of EREPLACE functionality.

For single character replacement, CONVERT is the more efficient. However if you need portability to Windows platforms you will need EREPLACE or CHANGE, since the line terminator is two characters long.

Also, I doubt very much that the "\r" notation will work properly with the CONVERT function in server jobs, since it would replace "\" and "r" separately. Similarly, I believe EREPLACE and CHANGE would seek out explicit instances of "\r". That is, DataStage BASIC does not handle shell escapes. Specify Char(10).

All these functions can be found in the DataStage BASIC manual.

Oracle REPLACE is similar to EREPLACE and CHANGE in Universe BASIC.

Yes!

Sreenivasulu wrote:U can use the REPLACE function of Datastage to do this.

I was really reacting to this post, of course!

Sorry.

Don't be sorry, how were you supposed to know? Ray doesn't usually quote because you get less points when you quote.

Fewer.

ray.wurlod wrote:Fewer.

Yes, yes, I know, not sure what I was thinking... 'fewer' for things that can be counted individually, and 'less' for those things that can't be. Mostly. I'd edit my original post but it would ruin the whole Feng Shui of it.