Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: INSTR Help
> Here is a puzzle!
>
> A text field contains this info:
>
> TEXT
> ----------------------------------------------------
> Split = 25% of $8715.27 Value Before Uplift
>
> I want to put parenthesis around the words:
>
> Value Before Uplift
>
> I can easily get the one on the end by taking the
> field and doing:
>
> set text = text || ')'
>
> HOW DO I get the right parenthesis to be before the
> word Value?
Use instring (INSTR) to locate the position of the word Value.
Substring the the text breaking it up into two pieces then stitch them back together again concatenating in the left parenthesis.
Or, of course, just use Replace to replace Value with (Value.
Daniel A. Morgan Received on Wed Mar 14 2001 - 00:25:40 CST
![]() |
![]() |