<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:x = "urn:schemas-microsoft-com:office:excel" xmlns:p = "urn:schemas-microsoft-com:office:powerpoint" xmlns:a = "urn:schemas-microsoft-com:office:access" xmlns:dt = "uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s = "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs = "urn:schemas-microsoft-com:rowset" xmlns:z = "#RowsetSchema" xmlns:b = "urn:schemas-microsoft-com:office:publisher" xmlns:ss = "urn:schemas-microsoft-com:office:spreadsheet" xmlns:c = "urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc = "urn:schemas-microsoft-com:office:odc" xmlns:oa = "urn:schemas-microsoft-com:office:activation" xmlns:html = "http://www.w3.org/TR/REC-html40" xmlns:q = "http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc = "http://microsoft.com/officenet/conferencing" XMLNS:D = "DAV:" XMLNS:Repl = "http://schemas.microsoft.com/repl/" xmlns:mt = "http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2 = "http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda = "http://www.passport.com/NameSpace.xsd" xmlns:ois = "http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir = "http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds = "http://www.w3.org/2000/09/xmldsig#" xmlns:dsp = "http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc = "http://schemas.microsoft.com/data/udc" xmlns:xsd = "http://www.w3.org/2001/XMLSchema" xmlns:sub = "http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec = "http://www.w3.org/2001/04/xmlenc#" xmlns:sp = "http://schemas.microsoft.com/sharepoint/" xmlns:sps = "http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs = "http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf = "http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p = "http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf = "http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss = "http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi = "http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi = "http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver = "http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m = "http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels = "http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp = "http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t = "http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m = "http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl = "http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl = "http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" XMLNS:Z = "urn:schemas-microsoft-com:" xmlns:st = ""><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16490">
<STYLE>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</STYLE>
<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:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.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>
</HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Segoe UI" lang=EN-US link=blue vLink=purple>
<DIV>To get the whole course section to download correctly we use the following i-descriptor:</DIV>
<DIV> </DIV>
<DIV>:AE DICT COURSES C26CRS.DESC.SV<BR>Top of "C26CRS.DESC.SV" in "DICT COURSES", 9 lines, 112 characters.<BR>*--: P7<BR>001: I<BR>002: CONVERT(@VM,' ',CRS.DESC)<BR>003: <BR>004: SV Description<BR>005: 50T<BR>006: S<BR>007: <BR></DIV>
<DIV>I'm not able to get the same results using an EVAL statement.</DIV>
<DIV> </DIV>
<DIV>Scott</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Scott Howder<BR>Assistant CIO<BR>Cedarville University<BR><A href="mailto:howders@cedarville.edu">howders@cedarville.edu</A> <BR>937-766-7905</DIV>
<DIV><BR>>>> On 3/23/2010 at 12:16 PM, in message <01c401cacaa4$3c2845c0$b478d140$@edu>, "Jeffery G. Summers" <jsummers@transy.edu> wrote:<BR></DIV>
<TABLE style="MARGIN: 0px 0px 0px 15px; FONT-SIZE: 1em" border=0 bgColor=#f3f3f3>
<TBODY>
<TR>
<TD>
<DIV style="BORDER-LEFT: #050505 1px solid; PADDING-LEFT: 7px">
<DIV class=Section1>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">I gave Brian’s CONVERT suggestion a whirl but have run into a problem.</SPAN><SPAN style="COLOR: #1f497d"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">My sample course record’s CRS.DESC is stored as:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d; FONT-SIZE: 10pt">A course designed to provide the student with a^253basic understanding of the nature and principles^253of war, national power, and the Department of^253Defense role in the organization of national^253security. The student also develops leadership^253abilities by participating in a military^253organization, the cadet corps, which offers a wide^253variety of situations demanding effective^253leadership. Course taught at the University of^253Kentucky.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Doing a SELECT and DOWNLOAD COURSES CRS.DESC it comes out (as expected):<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d; FONT-SIZE: 10pt">"A course designed to provide the student with a"<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Doing DOWNLOAD COURSES EVAL “CONVERT(@VM,’ ‘,CRS.DESC)” it comes out as:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d; FONT-SIZE: 10pt">"A course designed to provide the student with a basic understanding of the nature and principles of war, national power, and t"<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">All of my descriptions stop at 126 characters (the field itself is 50 characters). Is there something else I’m missing? Any suggestions? Thanks!<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN style="COLOR: black">Regards,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Jeffery G. Summers<BR>Administrative Computing<BR>Transylvania University<BR>Office: 859-233-8134<BR>Direct: 859-233-8139 <o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu] <B>On Behalf Of </B>Brian McGuire<BR><B>Sent:</B> Friday, March 19, 2010 3:09 PM<BR><B>To:</B> Cedarville DOWNLOAD Users<BR><B>Subject:</B> Re: [Download-List] Extracting multi-values as one block of text<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN style="COLOR: navy">I usually do a CONVERT(@VM , ‘ ‘, CRS.DESC) for this. That second parameter is a space between quotes.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: navy"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 7.5pt">Brian McGuire, Ph.D., MAS</SPAN></B><SPAN style="COLOR: navy"><o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 7.5pt">Executive Director</SPAN></B><SPAN style="COLOR: navy"><o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 7.5pt">______________________________</SPAN></B><SPAN style="COLOR: navy"><o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 7.5pt">Office of Institutional Research</SPAN></B><SPAN style="COLOR: navy"><o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 7.5pt">Direct: 602-639-6551<o:p></o:p></SPAN></B></P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: navy; FONT-SIZE: 7.5pt"><A href="mailto:bmcguire@gcu.edu">bmcguire@gcu.edu</A></SPAN></B><SPAN style="COLOR: navy"><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN style="COLOR: navy"><o:p> </o:p></SPAN></P>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu] <B>On Behalf Of </B>Jeffery G. Summers<BR><B>Sent:</B> Friday, March 19, 2010 11:51 AM<BR><B>To:</B> Download<BR><B>Subject:</B> [Download-List] Extracting multi-values as one block of text<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I’ve always used NUM.VALUES for a multi-valued field, but can DOWNLOAD extract data (like CRS.DESC) as one column including all the lines of text? I can do this in Querybuilder using reformat and I’ve never investigated whether DOWNLOAD could do the same. If so this could be very useful…is this possible and if so, how? Thanks!<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN style="COLOR: black">Regards,<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Jeffery G. Summers<BR>Administrative Computing<BR>Transylvania University<BR>Office: 859-233-8134<BR>Direct: 859-233-8139 <o:p></o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"><o:p> </o:p></SPAN></P>
<DIV style="TEXT-ALIGN: center" class=MsoNormal align=center><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt">
<HR align=center SIZE=2 width="100%">
</SPAN></DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 10pt">This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"><o:p></o:p></SPAN></P></DIV></DIV></TD></TR></TBODY></TABLE></BODY></HTML>