Hey that’s neato… you learn something every day. Everyone can ignore my suggestion and use this one.
Reese Reese E. Walker Lead Financial Systems Analyst Phoebe Putney Memorial Hospital Phone: (229) 312-4259 Email: [email protected] <mailto:[email protected]> 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 ----------------------------------------- Disclaimer: The HIPAA Final Privacy Rule requires covered entities to safeguard certain Protected Health Information (PHI) related to a person's healthcare. Information being faxed to you may include PHI after appropriate authorization from the patient or under circumstances that do not require patient authorization. You, the recipient, are obligated to maintain PHI in a safe and secure manner. You may not re-disclose without additional patient consent or as required by law. Unauthorized re-disclosure or failure to safeguard PHI could subject you to penalties described in federal (HIPAA) and state law. If you the reader of this message are not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, please notify us immediately and destroy the related 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
