All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Hi All, There are some issues that everyone should be aware of when downloading csv files to be looked at in Excel. Excel by default looks for a field delimiter of tab which is ASCII code 9 (FD 9). If you download as a *.csv file, when you open it in Excel it will not ask any questions. It will simply suck the file in and put the data in columns, dropping leading and trailing zeros and other possibly undesirable things. If you download as a tab delimited file with an extension of 'txt' (or just about anything except 'csv'), Excel will suck the data into columns as expected but will also give you the option to "predefine" each data column to some extent. For most purposes, I use "9" as my download delimiter for stuff that I will run for others. For stuff that the user will run, I will usually set up the spreadsheet for them first with all columns preset and show them how to use the "Get external data" or "Refresh data" capabilities of Excel. Donald F. Stewart Sr. Programmer Analyst Upson Regional Medical Center 801 W. Gordon St. Thomaston, GA 30286 (706)647-8111 x1696 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin McConnell Sent: Saturday, February 25, 2006 4:07 PM To: 'Kathy Bryant'; 'Lawrence, Mitchell'; 'Gayle Taylor'; '[EMAIL PROTECTED] com' Subject: RE: [MEDITECH-L] SPOOL TO EXCEL All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== -- This message has been scanned by the Securiant SpiderISA for spam and viruses, and is believed to be safe and clean. -- This message has been scanned by the Securiant SpiderISA for spam and viruses, and is believed to be safe and clean. _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
