[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