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!

Replacing characters in a comma delimited string

Area51Feb 7 2017 — edited Feb 9 2017

Dear all

I have a requirement where i need to replace the first three characters in a comma separated string.

Example : EP_123,EP_234,EP_345,PR_123,PR_234,PR_345

I need the output as 123,234,345,123,234,345.

Having to replace different sets of characters is proving tricky as ReplaceStr function can only handle one character set at any one time.

Please help.

Thanks

This post has been answered by Denzz on Feb 9 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 9 2017

Added on Feb 7 2017

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

15 comments

856 views