Skip to Main Content
Forums

Oracle Forms

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!

Removing brackets from char strings

424150Jun 14 2006 — edited Jun 14 2006
Ok, so its not exactly a forms question but I'm trying to do it in a forms procedure so who can help with this one:

I need to remove a series of brackets from a character string

e.g. "NIM(AV)3(LA)1" should be "NIMAV3LA1"

I don't think it should be too difficult but I've gotten myself lost in a series of SUBSTR and INSTR so thought I'd share my pain.

Many thanks..........
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2006
Added on Jun 14 2006
#forms, #moved-from-devops
5 comments
759 views