xsl-list
[Top] [All Lists]

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

2004-07-13 00:50:45
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