RE: how to replace a part of a string with a newline??

FAQ,

> Ive got this string :
>
> Importer__OPT__Trading Company__OPT__Service Provider
>
> How do i make it equivalent to
> - Importer
> - Trading Company
> - Service Provider
>
>
> Ive tried using translate function, but it replaces all
> instances of the
> letters O,P,T as well.I did something like:
>
> translate(text(),'__OPT__',':')
>
> It gives the following output is Importer:rading
> Company:Service rovider
> which i dont want.

<http://www.dpawson.co.uk/xsl/sect2/replace.html>.

Cheers,

Jarno - Claire Voyant: Mercy (cut rate box)