David: You might try using Microsoft Access. I have been successful in parsing large amounts of data, however, I admit not as long as the data lines you are referencing. Put your file into a *.txt name and then open in Access. It will allow you to parse as you do in excel. Hope this works for you.
Sheryl Isenbart, MBA/HCM Delivery Manager CTG HealthCare Solutions 312 Plum Street, Suite 700 Cincinnati, OH 45202 Office: (719)765-4044 Mobile: (626) 590-1025 VM: (800) 992-5350 x 1873 EMAIL: [EMAIL PROTECTED] WEB: www.ctghs.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David McAllister Sent: Wednesday, June 27, 2007 7:43 AM To: Meditech-l List Subject: [MEDITECH-L] Sort of kind of off topic - parsing extremely longlines I am working with a .sdf file whose lines are each 22,686 characters (bytes) long. I need to parse out about 150 individual pieces of data from each line but I am having trouble finding ANY program that can read a line that long. Ultimately I plan to script the extracted data into meditech using BWS. But first I have to parse these 100 mile long lines of data. Does anyone have experience parsing info out of a line this long? If so, how??!! When I import a line into excel, it puts the whole 23K line into cell A1, which of course does me no good. Any ideas...? TIA. David McAllister, MT(ASCP) Systems Analyst/Programmer Jeff Anderson Reg. Med. Ctr. Meridian, Mississippi Office: 601-553-6027 (M-F 0500-1330 central) Email: [EMAIL PROTECTED] *********************************************************** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you believe that you have received this email in error, please contact the sender. ************************************************************ =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com To check the status of the meditech-l, visit MTUsers.NET For help, email [EMAIL PROTECTED] Please visit and add information to the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from this computer. =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com To check the status of the meditech-l, visit MTUsers.NET For help, email [EMAIL PROTECTED] Please visit and add information to the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com
