<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: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="" 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;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 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.verdana
{mso-style-name:verdana;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle23
{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>
<!--[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-US link=blue vlink=purple>
<div class=Section1>
<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: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"'> Jeffery G. Summers
[mailto:jsummers@transy.edu] <br>
<b>Sent:</b> Tuesday, March 23, 2010 12:58 PM<br>
<b>To:</b> 'Ohlandt, George W.'<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:#1F497D'>This did the trick! Thanks
George!!<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: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"'> Ohlandt, George W.
[mailto:ohlandtg@musc.edu] <br>
<b>Sent:</b> Tuesday, March 23, 2010 12:53 PM<br>
<b>To:</b> 'Cedarville DOWNLOAD Users'<br>
<b>Cc:</b> 'Bill Pizer'; 'Jeffery G. Summers'<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 class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>I've run into the same problem in other fields. Have you
tried this trick?</span></span><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'> <o:p></o:p></span></p>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>DOWNLOAD COURSES CRS.DESC NUM.VALUES ALL DEFAULT VALUE.SEPARATOR '
'</span></span><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'> <o:p></o:p></span></p>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>You may need to add a DEFAULT SUBVALUE.SEPARATOR ' ' as well.</span></span><span
style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333'><o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>George W. Ohlandt </span></span><span
style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>Executive Director, Enrollment Management </span></span><span
style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>Medical University of South Carolina </span></span><span
style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'>843.792.3813 </span></span><span style='font-size:
9.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=verdana><span style='font-family:"Trebuchet MS","sans-serif";
color:black'><a href="mailto:ohlandtg@musc.edu">ohlandtg@musc.edu</a>
</span></span><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p> </o:p></span></p>
</div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";color:#333333'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:#333333'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:#333333'>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <b>On Behalf Of </b>Bill Pizer<br>
<b>Sent:</b> Tuesday, March 23, 2010 12:31 PM<br>
<b>To:</b> Download<br>
<b>Subject:</b> Re: [Download-List] Extracting multi-values as one block of
text</span><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>We have always had a problem downloading the Course Description
using multiple tools all seem to stop at 126 characters. Informer is
about the only thing that seems to work and even that is iffy. I'd love
to hear if anybody has cracked this egg.<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><br>
Bill Pizer <o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>Associate Director of MIS<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>The Sage Colleges<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>45 Ferry Street<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>Troy, NY 12180<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>518-244-2087 (office)<br>
<br>
<span style='border:solid windowtext 1.0pt;padding:0in'><img border=0
width=100 height=100 id="_x0000_i1026" src="cid:~WRD000.jpg"
alt="Image removed by sender."></span><o:p></o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'>---------------------------------------<br>
Original E-mail <br>
From: "Jeffery G. Summers" <jsummers@transy.edu><br>
Date: 03/23/2010 12:16 PM<br>
To: Download <download-list@cedarville.edu><br>
Subject: Re: [Download-List] Extracting multi-values as one block of text<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:9.0pt;font-family:"Trebuchet MS","sans-serif";
color:#333333'><o:p> </o:p></span></p>
<div>
<div>
<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:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>My sample course record’s
CRS.DESC is stored as:</span><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";
color:#1F497D'>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.</span><span style='color:#333333'><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):</span><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";
color:#1F497D'>"A course designed to provide the student with a"</span><span
style='color:#333333'><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:</span><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";
color:#1F497D'>"A course designed to provide the student with a basic
understanding of the nature and principles of war, national power, and t"</span><span
style='color:#333333'><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!</span><span
style='color:#333333'><o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='color:black'>Regards,</span><span
style='color:#333333'><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 </span><span style='color:#333333'><o:p></o:p></span></p>
</div>
<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";
color:#333333'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:#333333'> 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</span><span style='color:#333333'><o:p></o:p></span></p>
</div>
</div>
<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.</span><span style='color:#333333'><o:p></o:p></span></p>
<div>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:navy'>Brian McGuire, Ph.D., MAS</span></b><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:navy'>Executive Director</span></b><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:navy'>______________________________</span></b><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:navy'>Office of Institutional Research</span></b><span style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:navy'>Direct: 602-639-6551</span></b><span
style='color:#333333'><o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:navy'><a href="mailto:bmcguire@gcu.edu">bmcguire@gcu.edu</a></span></b><span
style='color:#333333'><o:p></o:p></span></p>
</div>
<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";
color:#333333'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:#333333'> 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</span><span
style='color:#333333'><o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span style='color:#333333'>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></span></p>
<p class=MsoNormal><span style='color:black'>Regards,</span><span
style='color:#333333'><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 </span><span style='color:#333333'><o:p></o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#333333'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>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='color:#333333'><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</body>
</html>