Denise,
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 McNeil
Boston Software Systems
866 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 field
Greetings
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!
Denise
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.
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
