[Bulk] Character replacement

[Ken Langendock]

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/d358b238/attachment.htm