Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Function REPLACE

Alex1Jul 4 2012 — edited Jul 9 2012

I need to replace different characters in one column. Actually my formula looks like this: REPLACE(REPLACE(@{var},' ','%20'),'+','%2B') .... If I need to do 10 replaces...my formula grows much... Is there any solution about it?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2012

Added on Jul 4 2012

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

11 comments

239 views