<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@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:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
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","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</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=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Cynthia,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>This is old, but I’ll give a quick two cents in case you
never got an answer… <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You can probably do this with an eval statement that calls
splice and splice SA.AWARD to SA.AMOUNT using a either a selected delimiter or
maybe put a value mark in as a delimiter. If you use a specific delimiter then
you would want to wrap a convert around the splice and convert all instances of
the delimiter into a value mark. And because there could be any number of
awards you should use NUM.VALUES ALL after the eval. So it is probably best to
use this field as the last one in a downloaded statement. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>HTH,<o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";
color:#1F497D'>Jeff Flynt<br>
</span></b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";
color:#1F497D'><br>
</span><b><span style='font-size:8.5pt;font-family:"Arial","sans-serif";
color:#7D0000'>Arizona State University Foundation</span></b><span
style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#1F497D'> </span><span
style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#00007C'>|</span><span
style='font-size:8.5pt;font-family:"Arial","sans-serif";color:#FB9500'> <b>Information
Resources Management <br>
</b></span><span style='font-size:8.5pt;font-family:"Arial","sans-serif";
color:#7C7C7C'>Applications Systems Analyst, Sr.<br>
P.O. Box 875905 | Tempe, Arizona | 85287-5905<br>
PH: 480.965.6870 | Fax: 480.965-6686 | e-mail: jeff.flynt@asu.edu<br>
<br>
</span><a href="http://www.asufoundation.org/" target="_blank"><span
style='font-size:8.5pt;font-family:"Arial","sans-serif";color:blue;text-decoration:
none'><img border=0 width=208 height=48 id="Picture_x0020_1"
src="cid:image001.gif@01C7CDE2.DB27F380"
alt="http://www.asufoundation.org/gfx/asuf_logo_gray.gif"></span></a><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b>On Behalf Of </b>Jon Wells<br>
<b>Sent:</b> Tuesday, July 03, 2007 8:41 AM<br>
<b>To:</b> download-list@cedarville.edu<br>
<b>Subject:</b> [Download-List] Can Download do... ?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi all,<br>
<br>
Can this be done with out having to create new I-descriptors? ---><br>
<br>
[From our Institutional Researcher]<br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I need to
download student financial aid records. I have no problem downloading them in
each of the following formats:<br>
<br>
1. Student
ID AwardName1 AwardName2
AwardName3 AwardAmount1 AwardAmount2 AwardAmount3<br>
<br>
2. Student
ID AwardName1 AwardAmount1<br>
Student
ID AwardName2 AwardAmount2<br>
Student
ID AwardName3 Award Amount3<br>
<br>
What I'd like to be able to do is the following:<br>
Student
ID AwardName1 AwardAmount1
AwardName2 AwardAmount2 AwardName3 AwardAmount3<br>
<br>
I know I've done it before – probably using the by.exp and num.subvalues
commands, but I can't remember how to do it for the life of me! {grrrrr}<br>
<br>
Can you help? The actual file & field names are below:<br>
<br>
File: SA.2006<br>
Fields: Student ID = SA.STUDENT.ID <br>
AwardNames =
SA.AWARD (multi-valued field)<br>
AwardAmounts = SA.AMOUNT
(multi-valued field)<br>
<br>
<br>
Thanks!<br>
Cynthia<br>
<br>
<br>
<br>
</span><o:p></o:p></p>
<p>*-----------------------------------------------------------*<br>
Jon Wells<br>
Database
Administrator
Beloit College<br>
Information Services &
Resources Beloit,
Wisconsin<br>
608-363-2290
wellsj@beloit.edu 608-363-2100 (fax)<br>
*-----------------------------------------------------------*<o:p></o:p></p>
</div>
</body>
</html>