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!

Replace multiple special char in a string

DRMSAMDec 10 2016 — edited Dec 15 2016

Hello Everyone,

I am trying to write a derived property to replace spcl charachters in a property with underscores. The function HasCharacters gives me whether the spcl is present or not, but how can the ReplaceStr be used to have all the characters replaced. For example, If(HasCharacters(propvalue(Custom.XXXX),[/,space,&,comma,@,!,#,$]), ReplaceStr(Propvalue(Custom.XXXX),[space],_,T),propvalue(Custom.XXXX)) will replace space with undescore, but how to to add condition for /,&,#,! etc also in the same property? And if the property has multiple spcl characthers, how can all of them as defined be replaced with underscores?

Thanks in Advance

Sam

This post has been answered by Murali Pasumarti on Dec 12 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2017

Added on Dec 10 2016

#business-intelligence-applications, #hyperion-drm-analytical-master-data, #system-management-and-integration

2 comments

1,101 views