[Download-List] Email addresses

[Sally Crawford]

It works like a charm!  Thank you.

Sally

============================================================================
Sally Crawford * Systems Analyst
Ocean County College * College Drive * PO Box 2001, Toms River, NJ 08754-2001
Tel 732-255-0426 * Fax 732-255-0501 * scrawford at ocean.edu * www.sungardhe.com *www.ocean.edu

CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary
and privileged information, and unauthorized disclosure or use is prohibited.  If you received
this e-mail in error,  please notify the sender and delete this e-mail from your system.


-----Original Message-----
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Scott Howder
Sent: Monday, October 15, 2007 3:07 PM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] Email addresses

Sally -

The following should do what you want:

DOWNLOAD STUDENTS \
   O06.STU.WEBADVISOR.LOGIN \
   LITERAL "" \
   FORMAT COMMA \
   COMMA.CHAR ";" QUOTE.CHAR "" \
FILE &HOLD& SALLY OVERWRITING NOPAGE

Scott


Scott Howder
Associate Director of Computer Services
Cedarville University
howders at cedarville.edu 
937-766-7905

>>> "Sally Crawford" <scrawford at ocean.edu> 10/15/2007 2:49 PM >>>
My goal is to create a list of student email addresses (actually
WebAdvisor logins) that can be placed in the 'BCC' campus email field
for a particular group.

Currently, this is my process:

To get email addresses with semi-colon:

:GET.LIST STARS 

>DOWNLOAD STUDENTS O06.STU.WEBADVISOR.LOGIN LITERAL "1" FORMAT COMMA
QUOTE.CHAR "" FILE &HOLD& SALLY OVERWRITING NOPAGE 

Paste data into Notepad.

Edit - replace ,1 with ;

Is there a better way?

Thanks for you help.

Sally

========================================================================
==========
Sally Crawford * Systems Analyst
Ocean County College * College Drive * PO Box 2001, Toms River, NJ
08754-2001
Tel 732-255-0426 * Fax 732-255-0501 * scrawford at ocean.edu *
www.sungardhe.com *www.ocean.edu

CONFIDENTIALITY: This e-mail (including any attachments) may contain
confidential, proprietary
and privileged information, and unauthorized disclosure or use is
prohibited.  If you received
this e-mail in error,  please notify the sender and delete this e-mail
from your system.


_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list