Greetings, I saw you mentioned scripting in using BWS (Boston WorkStation). The DataStation feature supports fixed length files (among lots of other file types). Anyhow the fixed length parser has a "records are X" characters long feature. You can then also mark off the lengths of "component" fields within the record. If you want, email either me, or our support team directly and we can help you out here - I see no need to create intermediate files here (and if that's what you want, the DataStation can help here was well) - let me know. Regards, Thom
Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sheryl Isenbart Sent: Wednesday, June 27, 2007 12:12 PM To: [EMAIL PROTECTED]; Meditech-l List Subject: Re: [MEDITECH-L] Sort of kind of off topic - parsing extremely longlines 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 =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= 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
