[Bulk] Character replacement

[David Morrison]

But what if there's more than one pipe character within the field?

David Morrison
PRISM guru
858-450-1414 ext. 4211

From: powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com [mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com at lists.sowder.com] On Behalf Of Ken Langendock
Sent: Tuesday, May 04, 2010 6:10 AM
To: 'Grace, Ron (Chipping Sodbury) UK'; powerh-l at lists.sowder.com
Subject: RE: [Bulk] Character replacement

Here is an excerpt from my CSV conversion routine...I haven't compiled it but it is all here

  DEFINE D-Pipe = INDEX(fieldname OF filename, "|")

  TEMP T-Record CHARACTER * 60
  ITEM T-Record = fieldname OF filename[2:D-Pipe -1] IF fieldname OF filename[1:1] = '|' &
               ELSE fieldname OF filename[1:D-Pipe -1] + " " + fieldname OF filename[D-Pipe +1:60]
                    IF D-Pipe NE 0 &
               ELSE fieldname OF filename


From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com [mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On Behalf Of Grace, Ron (Chipping Sodbury) UK
Sent: May 4, 2010 7:15 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] Character replacement

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.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.814 / Virus Database: 271.1.1/2853 - Release Date: 05/04/10 02:27:00
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100504/1f7aa9d4/attachment-0001.htm