Anil G wrote:
> > > e.g. lets say i have data into column as '(A + B + C) - (D + E)'
> > > I would like to have following : (
>
> Thanks for reply,
>
> But how do it can be done on 9i? REPLACE function does not solve this
> problem...
> meaning,
>
> If expression is like : (G1 + G2 + G11) * G12 * G22
>
> Then replace will have issues with G11 and G22 due to replace of G1 and
> G2
>
In this case regular expressions will be the best way. (except that it
does not come out of the box in 9i)
You could use a stored Java procedure to do the parsing/replacing (no
java regexp out of the box on 9i either, since it uses Java 1.3, I
think)
best,
Martin
Received on Fri Aug 11 2006 - 02:34:21 CDT
