Thanks
to all for your suggestions. I used Rich's example below and it worked
like a charm.
-----Original Message-----
From: Rich McNeil [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 11:57 AM
To: [EMAIL PROTECTED]
Subject: RE: [Talk] Zero Filling a fieldDenise,The current version of the DataStation returns the raw contents in an Excel spreadsheet. I've changed the next version (due out in about a month) so it returns formatted contents. Until then you could use something like Format(D(1), "000000000")Rich McNeilBoston Software Systems866 653 5105
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 fieldGreetings all,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?Many thanks!DeniseDenise Morrill
Clinical Systems Analyst
Spring Harbor Hospital
175 Running Hill Road
South Portland, ME 04106207.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
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.
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
