<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3660" name=GENERATOR></HEAD>
<BODY
style="FONT-SIZE: 12px; COLOR: rgb(51,51,51); FONT-FAMILY: 'Trebuchet MS',Verdana,sans-serif"
spellcheck="true">
<DIV dir=ltr align=left><SPAN class=Verdana><FONT color=#000000 size=3><SPAN
class=662334416-23032010><SPAN class=Verdana>I've run into the same problem in
other fields. Have you tried this trick?</SPAN></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=Verdana><FONT color=#000000 size=3><SPAN
class=662334416-23032010><SPAN
class=Verdana></SPAN></SPAN></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=Verdana><FONT color=#000000 size=3><SPAN
class=662334416-23032010><SPAN class=Verdana>DOWNLOAD COURSES CRS.DESC
NUM.VALUES ALL DEFAULT VALUE.SEPARATOR ' '</SPAN></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=Verdana><FONT color=#000000 size=3><SPAN
class=662334416-23032010><SPAN
class=Verdana></SPAN></SPAN></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=Verdana><FONT color=#000000 size=3><SPAN
class=662334416-23032010><SPAN class=Verdana>You may need to add a DEFAULT
SUBVALUE.SEPARATOR ' ' as well.</SPAN></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=Verdana><FONT color=#000000><FONT
size=3></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=Verdana><FONT color=#000000><FONT size=3>G<SPAN
class=662334416-23032010><SPAN class=Verdana>eorge W. Ohlandt
</SPAN></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=Verdana><FONT color=#000000><FONT size=3><SPAN
class=662334416-23032010><SPAN class=Verdana>Executive Director, Enrollment
Management </SPAN></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=Verdana><FONT color=#000000><FONT size=3><SPAN
class=662334416-23032010><SPAN class=Verdana>Medical University of South
Carolina </SPAN></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=Verdana><FONT color=#000000><FONT size=3><SPAN
class=662334416-23032010><SPAN class=Verdana>843.792.3813
</SPAN></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=Verdana><FONT color=#000000><FONT size=3><SPAN
class=662334416-23032010><SPAN class=Verdana><A
href="mailto:ohlandtg@musc.edu">ohlandtg@musc.edu</A>
</SPAN></SPAN></FONT></FONT></SPAN></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> 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<BR></FONT><BR></DIV>
<DIV></DIV>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.<BR>
<DIV><BR></DIV>
<DIV><BR>Bill Pizer
<DIV>Associate Director of MIS</DIV>
<DIV>The Sage Colleges</DIV>
<DIV>45 Ferry Street</DIV>
<DIV>Troy, NY 12180</DIV>
<DIV>518-244-2087 (office)<BR><BR><IMG alt=""
src="https://www.sage.edu/images/email/SageColorBarHeader.jpg"
NOSEND="1"><BR></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV>---------------------------------------<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<BR></DIV>
<DIV><BR>
<DIV xmlns="http://www.w3.org/TR/REC-html40" xmlns:st=""
xmlns:z="#RowsetSchema"
xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService"
xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/"
xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages"
xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types"
xmlns:spwp="http://microsoft.com/sharepoint/webpartpages"
xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships"
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"
xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature"
xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig"
xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup"
xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/"
xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart"
xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile"
xmlns:udcs="http://schemas.microsoft.com/data/udc/soap"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/"
xmlns:sp="http://schemas.microsoft.com/sharepoint/"
xmlns:ec="http://www.w3.org/2001/04/xmlenc#"
xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:udc="http://schemas.microsoft.com/data/udc"
xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp"
xmlns:ds="http://www.w3.org/2000/09/xmldsig#"
xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/"
xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/"
xmlns:ppda="http://www.passport.com/NameSpace.xsd"
xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml"
xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/"
xmlns:repl="http://schemas.microsoft.com/repl/" xmlns:d="DAV:"
xmlns:rtc="http://microsoft.com/officenet/conferencing"
xmlns:q="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:html="http://www.w3.org/TR/REC-html40"
xmlns:oa="urn:schemas-microsoft-com:office:activation"
xmlns:odc="urn:schemas-microsoft-com:office:odc"
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:b="urn:schemas-microsoft-com:office:publisher"
xmlns:rs="urn:schemas-microsoft-com:rowset"
xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:a="urn:schemas-microsoft-com:office:access"
xmlns:p="urn:schemas-microsoft-com:office:powerpoint"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:v="urn:schemas-microsoft-com:vml"><!--[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: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>
<!--[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]-->
<DIV lang=EN-US vlink="purple" link="blue">
<DIV class=Section1>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)">I gave Brian’s CONVERT
suggestion a whirl but have run into a problem.</SPAN><SPAN
style="COLOR: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)">My sample course record’s
CRS.DESC is stored as:<O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: rgb(31,73,125); FONT-FAMILY: 'Courier New'">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: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)">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: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: rgb(31,73,125); FONT-FAMILY: 'Courier New'">"A
course designed to provide the student with a"<O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)">Doing DOWNLOAD COURSES
EVAL “CONVERT(@VM,’ ‘,CRS.DESC)” it comes out as:<O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: rgb(31,73,125); FONT-FAMILY: 'Courier New'">"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: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)">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: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: rgb(31,73,125)"><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: rgb(31,73,125)"><O:P></O:P></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: rgb(181,196,223) 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
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-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">Brian
McGuire, Ph.D., MAS</SPAN></B><SPAN style="COLOR: navy"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">Executive
Director</SPAN></B><SPAN style="COLOR: navy"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">______________________________</SPAN></B><SPAN
style="COLOR: navy"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">Office
of Institutional Research</SPAN></B><SPAN
style="COLOR: navy"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'">Direct: 602-639-6551<O:P></O:P></SPAN></B></P>
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: 'Arial','sans-serif'"><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-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: rgb(181,196,223) 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
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-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><O:P></O:P></SPAN></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'">
<HR align=center width="100%" SIZE=2>
</SPAN></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">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-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><O:P></O:P></SPAN></P></DIV></DIV></DIV></DIV></BODY></HTML>