Perfect. Thanks.
Chad Kemp Information Systems Analyst Firelands Regional Medical Center 419-557-7874 From: [email protected] [mailto:[email protected]] Sent: Thursday, July 15, 2010 3:00 PM To: [email protected] Subject: RE: [talkbws] Working with CSV files 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 --- 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
