[Download-List] Extracting multi-values as one block of text

[Bill Pizer]

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.




Bill Pizer
 Associate Director of MIS
 The Sage Colleges
 45 Ferry Street
 Troy, NY  12180
 518-244-2087 (office)



 






---------------------------------------
Original E-mail 
From: "Jeffery G. Summers" <jsummers at transy.edu>
Date: 03/23/2010 12:16 PM
To: Download <download-list at cedarville.edu>
Subject: Re: [Download-List] Extracting multi-values as one block of text







I gave Brian’s CONVERTsuggestion a whirl but have run into a problem.


 


My sample course record’sCRS.DESC is stored as:


 


A course designed to provide the student with a^253basicunderstanding of the nature and principles^253of war, national power, and theDepartment of^253Defense role in the organization of national^253security. Thestudent also develops leadership^253abilities by participating in amilitary^253organization, the cadet corps, which offers a wide^253variety ofsituations demanding effective^253leadership.  Course taught at theUniversity of^253Kentucky.


 


Doing a SELECT and DOWNLOADCOURSES CRS.DESC it comes out (as expected):


 


"A course designed to provide the student with a"


 


Doing DOWNLOAD COURSES EVAL“CONVERT(@VM,’ ‘,CRS.DESC)” it comes out as:


 


"A course designed to provide the student with a basicunderstanding of the nature and principles of war, national power, and t"


 


All of my descriptions stop at126 characters (the field itself is 50 characters).  Is there somethingelse I’m missing?  Any suggestions?  Thanks!


 


 



Regards,


 


Jeffery G. Summers
Administrative Computing
Transylvania University
Office: 859-233-8134
Direct: 859-233-8139 



 




From:download-list-bounces at cedarville.edu[mailto:download-list-bounces at cedarville.edu] On Behalf Of Brian McGuire
Sent: Friday, March 19, 2010 3:09 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Extracting multi-values as one block oftext




 


I usually do a CONVERT(@VM , ‘ ‘,CRS.DESC)    for this.  That second parameter is a spacebetween quotes.


 



Brian McGuire, Ph.D., MAS


Executive Director


______________________________


Office of Institutional Research


Direct:      602-639-6551


bmcguire at gcu.edu



 




From:download-list-bounces at cedarville.edu[mailto:download-list-bounces at cedarville.edu] On Behalf Of Jeffery G.Summers
Sent: Friday, March 19, 2010 11:51 AM
To: Download
Subject: [Download-List] Extracting multi-values as one block of text




 


I’ve always used NUM.VALUES for a multi-valued field, butcan DOWNLOAD extract data (like CRS.DESC) as one column including all the linesof text?  I can do this in Querybuilder using reformat and I’ve neverinvestigated whether DOWNLOAD could do the same.  If so this could be veryuseful
is this possible and if so, how?  Thanks!


 


Regards,


 


Jeffery G. Summers
Administrative Computing
Transylvania University
Office: 859-233-8134
Direct: 859-233-8139 


 


 





This message is private and confidential. If you have received itin error, please notify the sender and remove it from your system.






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20100323/3bd815f0/attachment.html>