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

Jeffery G. Summers jsummers at transy.edu
Fri Mar 19 23:23:11 EDT 2010


Thanks Brian! 

Regards, 

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

----- Original Message ----- 
From: "Brian McGuire" <bmcguire at gcu.edu> 
To: "Cedarville DOWNLOAD Users" <download-list at cedarville.edu> 
Sent: Friday, March 19, 2010 3:09:27 PM GMT -05:00 US/Canada Eastern 
Subject: Re: [Download-List] Extracting multi-values as one block of text 




I usually do a CONVERT(@VM , ‘ ‘, CRS.DESC) for this. That second parameter is a space between 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, 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! 



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 it in error, please notify the sender and remove it from your system. 

_______________________________________________ download-list mailing list download-list at cedarville.edu http://mail.cedarville.edu/mailman/listinfo/download-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20100319/4b5dc800/attachment.html>


More information about the download-list mailing list