[Download-List] format SSN

[Brich, Richard W.]

e.g. if Person File
SELECT PERSON SAMPLE 2

 

2 records selected to list 0.

 

>DOWNLOAD PERSON \

  EVAL "CONVERT('-','',SSN)"

DOWNLOAD version 7.21

Creating temporary list DLMBRICHR56361

2 key(s) saved to 1 record(s).

2 records retrieved to list 1.

Overwriting existing select list.

2 records retrieved to list 1.

Using input file PERSON

Output to screen

 

"NNNNNNNNN"

"NNNNNNNNN"

 

2 records processed.    
EVAL 

	-----Original Message-----
	From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Moyers, Debra
S
	Sent: Tuesday, July 29, 2008 2:31 PM
	To: download-list at cedarville.edu
	Subject: [Download-List] format SSN
	
	

	Is it possible to remove the "-" from SSN in Dowload?  

	 

	Thanks in advance.

	 

	Debbie Moyers

	Business Analyst

	Lincoln Memorial University

	phone: (423) 869-6469

	fax: (423) 869-6368

	 

	 


________________________________

	This e-mail and any files transmitted with it are confidential
and are intended solely for the use of the individual or entity to whom
they are addressed. This communication may contain material protected by
the attorney-client privilege. If you are not the intended recipient or
the person responsible for delivering the e-mail to the intended
recipient, be advised that you have received this e-mail in error and
that any use, dissemination, forwarding, printing, or copying of this
e-mail is strictly prohibited. If you have received this e-mail in
error, please immediately notify the offices designated information
technology person by telephone at 800-325-0900. You will be reimbursed
for reasonable costs incurred in notifying us.
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080729/7d685e45/attachment.html>