Re: covert a part of a string into another
From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Thu, 10 Feb 2000 17:39:30 +0200
Message-ID: <38A2DBB2.E2D8326B_at_0800-einwahl.de>
from dual
/
Date: Thu, 10 Feb 2000 17:39:30 +0200
Message-ID: <38A2DBB2.E2D8326B_at_0800-einwahl.de>
select
replace ( replace ( 'blafasel exg:\webapp\shop\images\group2g:\webapp\shop\images\group1xybz' , 'g:\webapp\shop\images\group1' , '/images/group1' ) , 'g:\webapp\shop\images\group2' , '/images/group2' )
from dual
/
Martin
Immo Wetzel wrote:
>
> Hello
>
> I have a simple question
> How can I covert a part of a string into another ?
>
> i would like to change g:\webapp\shop\images\group1 into
> /images/group1
> and g:\webapp\shop\images\group2 into /images/group2
>
> both strings are only know at runtime.
>
> Thanks for any suggestion
>
> Immo
>
> --
> ----------------------------------------------------------------------------
>
> Immo Wetzel
> Fachhochschule Stralsund http://www.fh-stralsund.de
> University of applied science
Received on Thu Feb 10 2000 - 16:39:30 CET