<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD><TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2995" name=GENERATOR><!--[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="City"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"></o:SmartTagType><!--[if !mso]>
<STYLE>
st1\:*{behavior:url(#default#ieooui) }
</STYLE>
<![endif]-->
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
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:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
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 vLink=blue link=blue bgColor=white>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff size=2>That's
over 100 passes in our case, sometimes.</FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2>Hmmmm... thanks for the suggestion. Never thought of the MAX
verb.</FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2>However, I've decided to create a flat file record structure and I use it
to create the link to the DAT file, which is of course the text file I created
before hand.</FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff size=2>As a
matter of interest, in Unix, the following command is useful to add space
padding to strings, which I use to allow up to the maximum record length in my
flat file structure ...</FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff size=2>!cat
./mipss156t2b.ps | awk '{printf("%1251s\n", $0)}' >
./mlink_file.dat<BR></FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff size=2>The
mipss156t2b.ps is the data portion of the portable subfile and the
mlink_file.dat is the file referenced by the dictionary record reference. The
'$0' is saying, what ever comes out of that CAT command, use it as a parameter
into the printf() function, via the AWK command.</FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff size=2>I hope
this helps.</DIV></FONT></SPAN>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2>Cheers</FONT></SPAN></DIV>
<DIV><SPAN class=851044823-30112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> atla38@dsl.pipex.com
[mailto:atla38@dsl.pipex.com] <BR><B>Sent:</B> Friday, 1 December 2006 10:45
AM<BR><B>To:</B> Fernando Olmos<BR><B>Cc:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: System variables from within
QUIZ<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">You would run a pass to
each item, appending to the subfile for each item total, and then finally run a
pass as below,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">Set sum myresults keep
append<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">Rep sum itemA max itemB
max itemC max …etc…<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">If you know there are n
lines you can access the final row using ‘link to record n of * myresults’, if
not, make it an indexed subfile and give the results row a unique
key.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" color=black size=2><SPAN
style="FONT-SIZE: 10pt"><o:p></o:p></SPAN></FONT> </P></DIV><pre>**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,
then delete the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
</pre></BODY></HTML>