Formatting Problem with a “|” character 1

[Michael091170]

I hope someone can help me with a formatting problem.
The data from the fields of the view I am using is collated from a number of other fields so that it is formatted in report as follows:

Shareholder Details

Company1<br>null%<br>From: &nbsp;<br>To: Present<br>|Company2<br>null%<br>From: &nbsp<br>To: Present<br>|Company3<br>null%<br>From: &nbsp<br>To: Present<br>|Company4<br>null%<br>From: &nbsp<br>To: Present<br>|

When I change the text interpretation setting in format field to HTML it partly solves the problem and I get this:

Shareholder Details

Company1
null%
From:
To: Present
|Company2
null%
From:
To: Present
|Company3
null%
From:
To: Present
|Company4
null%
From:
To: Present|

This data is also displayed on our website and the web developers have managed to format it correctly:

Shareholder Details

Company1
null%
From:
To: Present
Company2
null%
From:
To: Present
Company3
null%
From:
To: Present
Company4
null%
From:
To: Present

I need to figure out how to remove the “|” character from this field. Does anyone have some useful code or suggestions as to how I can do this?
Thanks

 

[Katy44]

Could you use

Replace ({Shareholder Details}, "|", "")?

 

[Michael091170]

Thanks that worked well.