Character replacement

[Grace, Ron (Chipping Sodbury) UK]

Using Powerhouse on a HP3000
I have three 60 character comment fields that sometimes contain the '|' character, which causes problems as we use this as a delimiter when exporting files to an external application. I want to run a search/replace before the export to replace this character with a space. What's the easiest way to do this.

------------------------------------------
The contents of this message, together with any attachments, are intended only for the use of the person(s) to which they are addressed and may contain confidential and/or privileged information. Further, any medical information herein is confidential and protected by law. It is unlawful for unauthorized persons to use, review, copy, disclose, or disseminate confidential medical information. If you are not the intended recipient, immediately advise the sender and delete this message and any attachments. Any distribution, or copying of this message, or any attachment, is prohibited.
________________________________
Each of Hanson Aggregates, Hanson Aggregates UK, Hanson Bath & Portland Stone, Hanson Construction Projects, Hanson Contracting, Hanson Premix, Hanson Recycling, Ashbridge Concrete and Supamix is a trading name of Hanson Quarry Products Europe Limited. Hanson Quarry Products Europe Limited is a private limited company incorporated in England and Wales with registered number 00300002 and with registered address Hanson House, 14, Castle Hill, Maidenhead, Berkshire

Hanson Quarry Products Europe Limited is a member of the HeidelbergCement Group.

________________________________
This e-mail and any attachment transmitted with it are confidential and are intended for the named person's use only. The contents of the e-mail may contain sensitive and private or legally privileged information. If you have received this e-mail in error, please delete it (and any attachment) from your system and notify the sender immediately. You should not retain, copy or print the contents of this e-mail (or any attachment) nor should you, directly or indirectly, disclose or distribute the contents to anyone.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100504/121d8d1d/attachment.htm