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

Play the video

Subject: how to replace a part of a string with a newline??
From: Varun Suri <varunsuri@xxxxxxxxxxxxxxx>
Date: Tue, 13 Jul 2004 13:20:45 +0530

Hi

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.

Any easy way to do it??

Thanks in advance
Regards
Varun

Current Thread
how to replace a part of a string with a newline?? Varun Suri - Tue, 13 Jul 2004 13:20:45 +0530 <= Mukul Gandhi - Tue, 13 Jul 2004 01:57:39 -0700 (PDT) Varun Suri - Tue, 13 Jul 2004 14:54:07 +0530 Arulraj - Tue, 13 Jul 2004 02:30:50 -0700 (PDT) Peter Flynn - Tue, 13 Jul 2004 11:01:49 +0100

<- Previous	Index	Next ->
RE: parsing string or numbers, Jarno.Elovirta	Thread	Re: how to replace a part of , Mukul Gandhi
Re: question about XSLTC, George Cristian Bina	Date	RE: how to replace a part of , Jarno.Elovirta
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >