Greetings,
Here’s a way to do what you’re
asking…
What I’m doing here is finding out
how long the “trimmed” SSN is, then adding the appropriate number
of zeros to make the SSN length = 9
Dim MySSN as string
Dim i
MySSN=D(“SSN”)
‘ or whatever it is called
i=len(MySSN)
Do until i=9
MySSN= “0”
& MySSN
i=i+1
Loop
Enter MySSN
Regards,
Thom
-----Original Message-----
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Swisher, Vincent J.
Sent: Wednesday, March 31, 2004
11:50 AM
To: [EMAIL PROTECTED]
Subject: RE: [Talk] Zero Filling a
field
Maybe changing the data
type for the column on the spreadsheet to a TEXT variable might
help. Just throwing something out there. Don't know if it will work
or not.
-----Original Message-----
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of MORRILL,DENISE
Sent: Wednesday, March 31, 2004
11:37 AM
To: Boston Workstation Talk
(E-mail)
Subject: [Talk] Zero Filling a
field
I'm reading data from a
spreadsheet and although the column is formatted correctly in Excel for a
social sercurity number, the data station drops the leading zeros.
So 005112222 becomes 5112222.
Does anyone know how to
zero fill the field when the number of 0's will be variable?
Denise Morrill
Clinical Systems Analyst
Spring Harbor Hospital
175 Running Hill Road
South Portland, ME 04106
207.761.2265
[EMAIL PROTECTED]
CONFIDENTIAL
NOTICE: This email message, including any attachments, is intended only for the
use of the
intended recipient(s) and may contain information that is privileged,
confidential and prohibited from unauthorized disclosure under applicable law.
If you are not the intended recipient of this message, any dissemination,
distribution or copying of this message is strictly prohibited. If you received
this message in error, please notify the sender by reply email and destroy all
copies of the original message.
Spring
Harbor Hospital Maine's Mental Health Network
See our web page at http://www.lahey.org for a full directory
of Lahey sites, staff, services and career opportunities.
THIS MESSAGE IS INTENDED FOR THE USE OF THE PERSON TO WHOM IT IS ADDRESSED. IT
MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM
DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your
use of this message for any purpose is strictly prohibited. If you have
received this communication in error, please delete the message and notify the
sender so that we may correct our records.
