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@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 - 09:39:30 CST