<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:595.3pt 841.9pt;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>But what if there's more than one pipe character within the
field?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";
color:blue'>David Morrison</span><span style='font-size:11.0pt;font-family:
"Calibri","sans-serif";color:blue'> <br>
</span><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";
color:blue'>PRISM guru<br>
858-450-1414 ext. 4211</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
powerh-l-bounces+dmorrison=mcbrideelectric.com@lists.sowder.com
[mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com@lists.sowder.com] <b>On
Behalf Of </b>Ken Langendock<br>
<b>Sent:</b> Tuesday, May 04, 2010 6:10 AM<br>
<b>To:</b> 'Grace, Ron (Chipping Sodbury) UK'; powerh-l@lists.sowder.com<br>
<b>Subject:</b> RE: [Bulk] Character replacement<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Here is an excerpt from my CSV conversion routine…I haven’t
compiled it but it is all here<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'> DEFINE D-Pipe = INDEX(fieldname OF filename,
"|")<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'> TEMP T-Record CHARACTER * 60<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'> ITEM T-Record = fieldname OF filename[2:D-Pipe -1] IF
fieldname OF filename[1:1] = '|' &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'>
ELSE fieldname OF filename[1:D-Pipe -1] + “ “ + fieldname OF filename[D-Pipe
+1:60]<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'>
IF D-Pipe NE 0 &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'>
ELSE fieldname OF filename<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Courier New";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b>On
Behalf Of </b>Grace, Ron (Chipping Sodbury) UK<br>
<b>Sent:</b> May 4, 2010 7:15 AM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> [Bulk] Character replacement<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Using Powerhouse on a HP3000<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>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.<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-GB><br>
------------------------------------------ <br>
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.<o:p></o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-GB>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span lang=EN-GB
style='font-size:7.5pt;font-family:"Arial","sans-serif";color:gray'>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<br>
<br>
Hanson Quarry Products Europe Limited is a member of the HeidelbergCement
Group.</span><span lang=EN-GB><o:p></o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-GB>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><span lang=EN-GB style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:gray'>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.</span><span
lang=EN-GB><o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>No virus
found in this incoming message.<br>
Checked by AVG - www.avg.com<br>
Version: 9.0.814 / Virus Database: 271.1.1/2853 - Release Date: 05/04/10
02:27:00</span><o:p></o:p></p>
</div>
</body>
</html>