Can metacharacters be used in a select prompt?
Tim Cummings
tim.cummings@frequencymarketing.com
Fri, 28 Feb 2003 08:51:36 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2DF30.82A83080
Content-Type: text/plain;
charset="iso-8859-1"
Hey Chris,
Is the "%" for select prompts documented anywhere? I was looking through
the manual and found all of the metacharacter descriptions, but I saw
nothing on "%" in select prompts.
Tim Cummings
Cummings Consulting
Cincinnati, OH
513-576-1182
-----Original Message-----
From: Peter Bateman [mailto:shediac92@hotmail.com]
Sent: Friday, February 28, 2003 7:25 AM
To: chris.sharman@ccagroup.co.uk; tim.cummings@frequencymarketing.com;
powerh-l@lists.swau.edu
Subject: RE: Can metacharacters be used in a select prompt?
Chris:
To put metacharacters in a prompt, I would put the characters
in a define ... parm prompt.
ie DEFINE match_string char * 30 = parm prompt "Enter selection"
ACCESS ...
SELECT IF " " = match_string &
OR MATCHPATTERN ( (NAME + ADDRESS), TRUNCATE (match_string))
>From: "Chris Sharman" <chris.sharman@ccagroup.co.uk>
>To: "Tim Cummings" <tim.cummings@frequencymarketing.com>,
><powerh-l@lists.swau.edu>
>Subject: RE: Can metacharacters be used in a select prompt?
>Date: Fri, 28 Feb 2003 08:41:08 -0000
>
>
> >Quick question: HP3000 PH 8.1.9 C2
> >
> >I know that you can use something like bell@ in a field when supplying
>select >values in select mode, but is there a way to supply metacharacter
>patterns? I >know I can write the code to make this work but I don't want
>to write code. I >want to use native PH to do the work.
>
>Yes.
>
>The user should enter % to say treat this expression as a pattern.
>
>eg "%^(#|^)* *" for an identifier (alpha optionally followed by
>alphanumerics, with space padding to the end of the field).
>
>On a similar line, does anyone know how to have metacharacters treated
>normally when entering a choose parm ?
>Eg, we have email addresses keyed, but the find doesn't work, because the
>"@" always gets treated specially (PH 710G3, VMS 7.3). I'd thought it was
>only special at the end of an expression, but that doesn't seem to be the
>case. In fact I don't know what it means in the middle of an expression,
>but
>it finds precious little.
>
>Chris
>
>
>-----------------------------------------------------------------------
>
>Any views expressed in this message are those of the sender and not
>necessarily those of CCA Group. The unauthorized use, disclosure,
>copying or alteration of this message is forbidden. The contents of
>this message may be confidential and/or privileged, copyright CCA Group
>and are intended solely for the use of the individual or entity to whom
>they are addressed. Whilst this message has been scanned, CCA Group
>cannot guarantee that it is virus free or compatible with your systems
>and accepts no responsibility for any loss or damage arising from its
>use. The recipient is advised to run their own anti-virus software. If
>you receive this message in error please contact
>postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
>from your computer systems.
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
------_=_NextPart_001_01C2DF30.82A83080
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: Can metacharacters be used in a select prompt?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hey Chris,</FONT>
</P>
<P><FONT SIZE=3D2>Is the "%" for select prompts documented =
anywhere? I was looking through the manual and found all of the =
metacharacter descriptions, but I saw nothing on "%" in =
select prompts.</FONT></P>
<P><FONT SIZE=3D2>Tim Cummings</FONT>
<BR><FONT SIZE=3D2>Cummings Consulting</FONT>
<BR><FONT SIZE=3D2>Cincinnati, OH</FONT>
<BR><FONT SIZE=3D2>513-576-1182</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Peter Bateman [<A =
HREF=3D"mailto:shediac92@hotmail.com">mailto:shediac92@hotmail.com</A>]<=
/FONT>
<BR><FONT SIZE=3D2>Sent: Friday, February 28, 2003 7:25 AM</FONT>
<BR><FONT SIZE=3D2>To: chris.sharman@ccagroup.co.uk; =
tim.cummings@frequencymarketing.com; powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Can metacharacters be used in a select =
prompt?</FONT>
</P>
<P><FONT SIZE=3D2>Chris:</FONT>
</P>
<P><FONT SIZE=3D2>To put metacharacters in a prompt, I would put the =
characters</FONT>
<BR><FONT SIZE=3D2>in a define ... parm prompt.</FONT>
</P>
<P><FONT SIZE=3D2>ie DEFINE match_string char * 30 =3D parm prompt =
"Enter selection"</FONT>
</P>
<P><FONT SIZE=3D2>ACCESS ...</FONT>
<BR><FONT SIZE=3D2>SELECT IF " " =3D match_string =
&</FONT>
<BR><FONT SIZE=3D2> OR =
MATCHPATTERN ( (NAME + ADDRESS), TRUNCATE (match_string))</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2>>From: "Chris Sharman" =
<chris.sharman@ccagroup.co.uk></FONT>
<BR><FONT SIZE=3D2>>To: "Tim Cummings" =
<tim.cummings@frequencymarketing.com>, </FONT>
<BR><FONT SIZE=3D2>><powerh-l@lists.swau.edu></FONT>
<BR><FONT SIZE=3D2>>Subject: RE: Can metacharacters be used in a =
select prompt?</FONT>
<BR><FONT SIZE=3D2>>Date: Fri, 28 Feb 2003 08:41:08 -0000</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> >Quick question: HP3000 PH 8.1.9 =
C2</FONT>
<BR><FONT SIZE=3D2>> ></FONT>
<BR><FONT SIZE=3D2>> >I know that you can use something like =
bell@ in a field when supplying</FONT>
<BR><FONT SIZE=3D2>>select >values in select mode, but is there a =
way to supply metacharacter</FONT>
<BR><FONT SIZE=3D2>>patterns? I >know I can write the code =
to make this work but I don't want</FONT>
<BR><FONT SIZE=3D2>>to write code. I >want to use native PH =
to do the work.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Yes.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>The user should enter % to say treat this =
expression as a pattern.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>eg "%^(#|^)* *" for an identifier =
(alpha optionally followed by</FONT>
<BR><FONT SIZE=3D2>>alphanumerics, with space padding to the end of =
the field).</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>On a similar line, does anyone know how to have =
metacharacters treated</FONT>
<BR><FONT SIZE=3D2>>normally when entering a choose parm ?</FONT>
<BR><FONT SIZE=3D2>>Eg, we have email addresses keyed, but the find =
doesn't work, because the</FONT>
<BR><FONT SIZE=3D2>>"@" always gets treated specially (PH =
710G3, VMS 7.3). I'd thought it was</FONT>
<BR><FONT SIZE=3D2>>only special at the end of an expression, but =
that doesn't seem to be the</FONT>
<BR><FONT SIZE=3D2>>case. In fact I don't know what it means in the =
middle of an expression,</FONT>
<BR><FONT SIZE=3D2>>but</FONT>
<BR><FONT SIZE=3D2>>it finds precious little.</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Chris</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT =
SIZE=3D2>>-----------------------------------------------------------=
------------</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Any views expressed in this message are those of =
the sender and not</FONT>
<BR><FONT SIZE=3D2>>necessarily those of CCA Group. The =
unauthorized use, disclosure,</FONT>
<BR><FONT SIZE=3D2>>copying or alteration of this message is =
forbidden. The contents of</FONT>
<BR><FONT SIZE=3D2>>this message may be confidential and/or =
privileged, copyright CCA Group</FONT>
<BR><FONT SIZE=3D2>>and are intended solely for the use of the =
individual or entity to whom</FONT>
<BR><FONT SIZE=3D2>>they are addressed. Whilst this message =
has been scanned, CCA Group</FONT>
<BR><FONT SIZE=3D2>>cannot guarantee that it is virus free or =
compatible with your systems</FONT>
<BR><FONT SIZE=3D2>>and accepts no responsibility for any loss or =
damage arising from its</FONT>
<BR><FONT SIZE=3D2>>use. The recipient is advised to run their own =
anti-virus software. If</FONT>
<BR><FONT SIZE=3D2>>you receive this message in error please =
contact</FONT>
<BR><FONT SIZE=3D2>>postmaster@ccagroup.co.uk immediately, destroy =
any copies and delete it</FONT>
<BR><FONT SIZE=3D2>>from your computer systems.</FONT>
<BR><FONT SIZE=3D2>>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>>Subscribe: "subscribe" in message body =
to powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>>Unsubscribe: "unsubscribe" in message =
body to</FONT>
<BR><FONT SIZE=3D2>>powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>>This list is closed, thus to post to the list =
you must be a subscriber.</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>_______________________________________________________________=
__</FONT>
<BR><FONT SIZE=3D2>STOP MORE SPAM with the new MSN 8 and get 2 months =
FREE* </FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://join.msn.com/?page=3Dfeatures/junkmail" =
TARGET=3D"_blank">http://join.msn.com/?page=3Dfeatures/junkmail</A></FON=
T>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C2DF30.82A83080--