All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Why not just add a footnote to delimited format of .csv which can opened directly as an Excel spreadsheet. Attached is an example for an easy version... Kevin McConnell, PharmD. Clinical Consultant (713)480-6810 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Bryant Sent: Friday, February 24, 2006 1:15 PM To: 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 ====================================== Easier way... Print report to Spool. I have access to the MIS spooling file under BAR. Go to #40 Spooling Menu and select #19 Transmit Put in spool number, hit enter, Spool # Report Title / Comment Rec Len Use Position 1 For Printer Control? N Fixed/Variable V If Fixed: Record Length (Including Printer Control Position) If Variable: Record Terminator(s) CR/LF AUTOMATICALLY ENTERED If Other, Rec Term ASCII Codes Download To Your PC? Y Transfer Protocol ENTER THRU End of Page ASCII Codes ENTER THRU End of File ASCII Codes ENTER THRU Will ask Download to your PC? Y tell it where to download to (directory, folder) , name the file put extension of .txt on (sample ak1234.txt) -----Original message----- From: "Lawrence, Mitchell" [EMAIL PROTECTED] Date: Fri, 24 Feb 2006 18:46:46 -0600 To: "Gayle Taylor" [EMAIL PROTECTED] 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 > ====================================== > > Download your NPR/Spool file into an ascii text file (*.txt), then use > Tools (or Data, depending on your Excel version), Import External Data, > Import Data File. > > Unless your NPR/Spool is specifically delimited in some way, you should > probably import with a fixed column length rather than delimited. > > > Thank you, > Mitch Lawrence > Senior Applications Analyst - Advanced Report Writer > General Financials Support > CHRISTUS Information Management > Tel 361.881.3408 Fax 361.888.6117 > Mob 361.549.8456 > [EMAIL PROTECTED] > > > If someone has "Made your day", send them a Spirit Buck! > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Gayle Taylor > Sent: Thursday, February 23, 2006 9:59 AM > To: [EMAIL PROTECTED] com > Subject: [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 > ====================================== > > > Good Day, L-ers > > I have some questions regarding importing a NPR or spool file into an > Excel > spreadsheet. Does anyone out there have a procedure for this process > that > they are willing to share? We are Magic 5.4 SR3. > > TIA, > Gayle Taylor, LIS Coordinator > Sampson Regional Medical Center > 607 Beaman Street-PO Drawer 260 > Clinton, NC 28329 > (910)590-8709 > > > This email and any files transmitted with it are confidential and > intended > solely for the use of the individual or entity to whom they are > addressed. > If you are not the intended recipient you are notified that disclosing, > copying, distributing or taking any action in reliance on the contents > of > this information is strictly prohibited. If you have received this > email in > error please notify the sender and delete the email. Please note that > any > views or opinions presented in this email are solely those of the author > and > do not necessarily represent those of Sampson Regional Medical Center. > Finally, the recipient should check this email and any attachments for > the > presence of viruses. Sampson Regional Medical Center accepts no > liability > for any damage caused by any virus transmitted by this email. Sampson > Region Medical Center - 910-592-8511 > > > > > > > _______________________________________________ > meditech-l mailing list > [EMAIL PROTECTED] > http://mtusers.com/mailman/listinfo/meditech-l > > > > _______________________________________________ > meditech-l mailing list > [EMAIL PROTECTED] > http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [EMAIL PROTECTED] http://mtusers.com/mailman/listinfo/meditech-l
How to create an NPR report as CSV file to upload to Excel.doc
Description: MS-Word document
_______________________________________________ meditech-l mailing list [EMAIL PROTECTED] http://mtusers.com/mailman/listinfo/meditech-l
