I use .csv files all the time and if you put a space comma true (
,true) after your data element in your actions window then it will work
fine. Mine looks like this:
Enter D("ACCT NBR" ,true) '4.07E+08
Tom Marquis
Application Analyst
North Kansas City Hospital
(816) 225-4232
________________________________
From: [email protected] [mailto:[email protected]]
Sent: Thursday, July 15, 2010 1:55 PM
To: [email protected]
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 email message, including any attachments, is for
the sole use of the intended recipient(s), and may contain privileged or
confidential information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
notify the sender of this email, 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
