<html 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">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<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>
<!--
/* Font Definitions */
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* 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.EmailStyle17
{mso-style-type:personal-compose;
font-family:Garamond;
color:windowtext;
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>
</head>
<body lang=EN-GB link=blue vlink=purple>
<div class=Section1>
<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:place w:st="on"><st1:country-region w:st="on">UK</st1:country-region></st1:place></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><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>
<BR>
</P></DIV>
</body>
</html>