Some quick checking of the help file says this: "If you modify the
DataStation Value property to D("Amount", True) then the number is
displayed more accurately.
^^^^^^^^^^^^^^^^^^^^^^^
James Walker
Systems Analyst
St Marys Health System
Knoxville, TN
Ph (865)545-7731
Fax (865)545-3007
^^^^^^^^^^^^^^^^^^^^^^^
[email protected]
07/15/2010 02:54 PM
Please respond to
[email protected]
To
[email protected]
cc
Subject
[talkbws] Working with CSV files
I?ve noticed that CSV files, when opened, will modify the displayed value
to a more simplified value. For example 4409354237 will display as
4.41E+09 and 05/02/1999 will display as 5/2/1999. Occasionally long values
will display as ########. When using Datastation it uses the displayed
value instead of the raw value. I thought that putting quotes around each
value in the file would force it to treat everything as text but no luck.
I can do a workaround but I am hopeful that there is an Excel setting that
I can use instead.
Chad Kemp
Information Systems Analyst
Firelands Regional Medical Center
419-557-7874
--- To post a message to this list, send mail to: [email protected] You
are currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
CONFIDENTIALITY NOTICE: This message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message.
--- To post a message to this list, send mail to: [email protected] You are
currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
