Thanks Thom, this works perfectly.
I notice that this is one of the options I'm offered when I type D. in the workstations VB editor and get a pick list of object functions. Is there a document anywhere that specs out what each of these various functions does? Thanks, Seth ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C. Blackwell Sent: Wednesday, February 20, 2008 1:36 PM To: [email protected] Subject: RE: [Talk] line terminators Greetings, The DataStation has a command that will help you here: D.FileReplace(FileName As String, sFrom As String, sTo As String) In your situation, use: D.FileReplace YourFileName, vbLF, vbCrLf Then D.Open.... Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Visit us in Booth 2471 at HIMSS08 - February 25-28 in Orlando, FL Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> 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. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Seth Bosack Sent: Wednesday, February 20, 2008 1:28 PM To: [email protected] Subject: [Talk] line terminators I'm working with a csv file from an outside vendor and loading data from it into Meditech using the datastation. My problem is that the file's line terminator is LF. Datastation is looking for CRLF. When I manually converted the file using a text editing tool, my script worked just fine. The vendor who is producing the file is struggling to get the CRLF line terminator. Anybody have any suggestions about how I could manage this using bws if my vendor falls down? Seth Seth Bosack MIS South County Hospital Wakefield, RI 401 788 1519 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
