<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<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:ns0="http://schemas.microsoft.com/office/2004/12/omml">
<head>
<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"/>
<!--[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:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
@font-face
{font-family:Calibri;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Garamond;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Garamond;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
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-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'>Sorry, yes, I have
done that. From our dictionary:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 06 Special Name
Char "-_'%#$" Decimal Char. "."
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 07 Generic
Retrieval "@" Multiline Heading
"^" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 08 Picture
Substitution "^" Message Substitution
"^" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<font size=3 color=blue face=Garamond><span style='font-size:12.0pt;font-family:
Garamond;color:blue'><br clear=all style='page-break-before:always'>
</span></font>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><br>
Metacharacters <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 01 Escape
"!" 06 Match Repeating ">" 11
Match Digit "#" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 02 Logical Or
"|" 07 Match Optional "<" 12 Match
Anything "@" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 03 Optional Repeat
"*" 08 Match Not "\" 13 Match
Null "0" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 04 Left Paren.
"(" 09 Match Any "?" 14
Reserved "[]=;&" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'> 05 Right Paren.
")" 10 Match Alpha "^" 15 Match
Kanji ":" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><font size=3 color=blue face=Garamond><span lang=EN-US
style='font-size:12.0pt;font-family:Garamond;color:blue'>Nick Butland</span></font><font
color=blue><span style='color:blue'> <br>
</span></font><font color=blue face=Garamond><span lang=EN-US style='font-family:
Garamond;color:blue'>IT Project Leader, Acco <st1:place w:st="on"><st1:country-region
w:st="on">UK</st1:country-region></st1:place></span></font><font color=blue><span
lang=EN-US style='color:blue'> </span><o:p></o:p></font></p>
<p style='margin-left:36.0pt'><font size=3 color=blue face=Garamond><span
lang=EN-US style='font-size:12.0pt;font-family:Garamond;color:blue'>Tel
01296-732150</span></font><font color=blue><span style='color:blue'> <br>
</span></font><font color=blue face=Garamond><span lang=EN-US style='font-family:
Garamond;color:blue'>Fax 01296-732151</span></font><font color=blue><span
style='color:blue'> <br>
</span></font><font color=blue face=Garamond><span lang=EN-US style='font-family:
Garamond;color:blue'><a href="mailto:nick.butland@acco.com"
title="mailto:nick.butland@acco.com">Email: nick.butland@acco.com</a></span></font><font
color=blue><span style='color:blue'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=blue face=Garamond><span
style='font-size:12.0pt;font-family:Garamond;color:blue'><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 lang=EN-US 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 lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Ken Langendock [mailto:Ken@Langendock.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> 25 March 2008 14:35<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> RE: Metacharacters &
pattern matching</span></font><span lang=EN-US><o:p></o:p></span></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 lang=EN-US
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Have you checked the
PDL for your dictionary and made sure that symbol is not used as a “Reserved”
or any other option in the “System Options” declaration of the PDL?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-US
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 lang=EN-US
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>This might cause
some weird issues.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-US
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 lang=EN-US
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Ken<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-US
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 lang=EN-US
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 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US 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>Butland, Nick<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, March 25, 2008
10:21 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> Metacharacters &
pattern matching<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>Let’s see if anyone else can crack this, because I am fed
up seeing the message “Invalid pattern specification. Check pattern syntax.”<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>Operating system is VMS v7.2-2,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>PowerHouse version 7.10.E6 (as it has been for rather a
long time…).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>I have an element which has an existing pattern of
“(\!|)*”. This allows any number of any alphanumeric character with the
exclusion of the “post” character, as we use this as a delimiter for some data
imports into Excel.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>Last week we had an interface fail as the result of the
inclusion of a £ character in the data. I have tried to amend the pattern to
something along the lines of “(\((!|)|£))*”, but this gives the error message
above. The current try has "(\£|(!|))*", but any input into this
triggers the message “There is a control character in this pattern.”<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>Any suggestions? So far as I am aware, all the entries on
the metacharacter screen are defaults.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt;
font-family:Garamond'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
margin-left:36.0pt'><font size=3 face=Garamond><span lang=EN-US
style='font-size:12.0pt;font-family:Garamond'>Nick Butland</span></font> <br>
<font face=Garamond><span lang=EN-US style='font-family:Garamond'>IT Project
Leader, Acco <st1:country-region w:st="on"><st1:place w:st="on">UK</st1:place></st1:country-region></span></font><span
lang=EN-US> </span><o:p></o:p></p>
<p style='margin-left:36.0pt'><font size=3 face=Garamond><span lang=EN-US
style='font-size:12.0pt;font-family:Garamond'>Tel 01296-732150</span></font> <br>
<font face=Garamond><span lang=EN-US style='font-family:Garamond'>Fax
01296-732151</span></font> <br>
<font face=Garamond><span lang=EN-US style='font-family:Garamond'><a
href="mailto:nick.butland@acco.com" title="mailto:nick.butland@acco.com">Email:
nick.butland@acco.com</a></span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><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 style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>DISCLAIMER<br>
*****************<br>
This email and any attachments thereto, may contain information which is
confidential and/or protected by intellectual property rights and are intended
for the sole use of the recipient(s) named above. Any use of the information
contained herein (including but not limited to total or, partial reproduction,
communication or, distribution in any form) or, the taking of any action in
reliance on the contents by persons other than the designated recipient(s) is
strictly prohibited.<br>
If you have received this email in error, please notify the sender either by
telephone or, by email and delete the material from any computer.<br>
<br>
Legal entity details can be found at the following link:
http://www.accoeurope.com/legalEntities/<br>
<br>
Thank you for your co-operation.<o:p></o:p></span></font></p>
</div>
</div>
<DIV><P><HR>
DISCLAIMER<BR>
*****************<BR>
This email and any attachments thereto, may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including but not limited to total or, partial reproduction, communication or, distribution in any form) or, the taking of any action in reliance on the contents by persons other than the designated recipient(s) is strictly prohibited.<BR>
If you have received this email in error, please notify the sender either by telephone or, by email and delete the material from any computer.<BR>
<BR>
Legal entity details can be found at the following link: http://www.accoeurope.com/legalEntities/<BR>
<BR>
Thank you for your co-operation.<BR>
</P></DIV>
</body>
</html>