<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:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns1="http://schemas.microsoft.com/office/2004/12/omml">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<meta name=Generator content="Microsoft Word 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
p
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{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";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle21
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@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><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>This situation just came up in our shop.
Thanks, Ken!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+rwitkopp=phxa.com@lists.sowder.com [mailto:powerh-l-bounces+rwitkopp=phxa.com@lists.sowder.com]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Ken Langendock<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, May 04, 2010 8:20
AM<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> FW: [Bulk] RE: [Bulk]
Character replacement</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Oops sorry I forgot
to add the rest. I stripped it down too much<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Ron, the ELSE
handles the pipe in any position after the first character<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>This is QTP code if
you haven’t figured it out already<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Each time the item
statement is present, a pipe will be removed. Add as many as you think you
need. I usually place 10 to be safe<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> DEFINE
D-Pipe = INDEX(fieldname OF filename, "|")<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> TEMP
T-Length INITIAL 60<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> TEMP
T-Record CHARACTER * 60<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> ITEM
T-Record = fieldname OF filename<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> ITEM
T-Record = T-Record[2:T-Length] IF T-Record[1:1] = '|' &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record[1:D-Pipe -1] + “ “ + T-Record[D-Pipe + 1:T-Length]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
IF <st1:place w:st="on"><st1:City w:st="on">D-Pipe</st1:City> <st1:State w:st="on">NE</st1:State></st1:place>
0 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> ITEM
T-Record = T-Record[2:T-Length] IF T-Record[1:1] = '|' &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record[1:D-Pipe -1] + “ “ + T-Record[D-Pipe + 1:T-Length]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
IF <st1:place w:st="on"><st1:City w:st="on">D-Pipe</st1:City> <st1:State w:st="on">NE</st1:State></st1:place>
0 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> ITEM
T-Record = T-Record[2:T-Length] IF T-Record[1:1] = '|' &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record[1:D-Pipe -1] + “ “ + T-Record[D-Pipe + 1:T-Length]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
IF <st1:place w:st="on"><st1:City w:st="on">D-Pipe</st1:City> <st1:State w:st="on">NE</st1:State></st1:place>
0 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> ITEM
T-Record = T-Record[2:T-Length] IF T-Record[1:1] = '|' &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record[1:D-Pipe -1] + “ “ + T-Record[D-Pipe + 1:T-Length]<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
IF <st1:place w:st="on"><st1:City w:st="on">D-Pipe</st1:City> <st1:State w:st="on">NE</st1:State></st1:place>
0 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE T-Record<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Grace, Ron
(Chipping Sodbury) <st1:country-region w:st="on"><st1:place w:st="on">UK</st1:place></st1:country-region>
[mailto:Ron.Grace@hanson.biz] <br>
<b><span style='font-weight:bold'>Sent:</span></b> May 4, 2010 9:51 AM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Ken@Langendock.com'<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Bulk] RE: [Bulk]
Character replacement<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Ken,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>I’ve just been
looking at the code in a bit more detail, won’t your code only check for
an occurrence of the “|” in the first character of the item, or am
I reading it wrong.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>The character may appear
in any of the 60 characters as it’s a user text field<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Ken Langendock
[mailto:ken.langendock@rogers.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 04 May 2010 14:10<br>
<b><span style='font-weight:bold'>To:</span></b> Grace, Ron (Chipping Sodbury) <st1:country-region
w:st="on"><st1:place w:st="on">UK</st1:place></st1:country-region>;
powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [Bulk] Character
replacement</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;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></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> DEFINE
D-Pipe = INDEX(fieldname OF filename, "|")<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'> TEMP
T-Record CHARACTER * 60<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><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></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><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></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
IF <st1:place w:st="on"><st1:City w:st="on">D-Pipe</st1:City> <st1:State w:st="on">NE</st1:State></st1:place>
0 &<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'>
ELSE fieldname OF filename<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face="Courier New"><span
style='font-size:11.0pt;font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Grace, Ron (Chipping Sodbury) <st1:country-region
w:st="on"><st1:place w:st="on">UK</st1:place></st1:country-region><br>
<b><span style='font-weight:bold'>Sent:</span></b> May 4, 2010 7:15 AM<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> [Bulk] Character
replacement<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Using Powerhouse on a
HP3000<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;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></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><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></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=1 color=gray
face=Arial><span lang=EN-GB style='font-size:7.5pt;font-family:Arial;
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 <st1:country-region w:st="on">England</st1:country-region>
and <st1:country-region w:st="on">Wales</st1:country-region> with registered
number 00300002 and with registered address Hanson House, 14, Castle Hill, Maidenhead,
<st1:place w:st="on">Berkshire</st1:place><br>
<br>
Hanson Quarry Products Europe Limited is a member of the HeidelbergCement
Group.</span></font><span lang=EN-GB><o:p></o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><font size=1 color=gray face=Arial><span lang=EN-GB
style='font-size:7.5pt;font-family:Arial;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></font><span lang=EN-GB><o:p></o:p></span></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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></font><o:p></o:p></p>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2 FACE="Arial">NOTICE: The information contained in this e-mail and any attachments is confidential and may be privileged or otherwise protected from disclosure. This e-mail is intended solely for the use of the named addressee. Any other use, printing, copying, disclosure or dissemination may be subject to legal restriction. If you are not the intended recipient, please contact the sender and delete all copies including any attachments.</FONT></P>