Greetings, I am guessing you set up the delimiter to be *.
Try this for your file replace command: D.FileReplace "C:\Your file.rap", "~", vbCrLf 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 <http://www.bostonworkstation.com/customer_center/special_events.aspx> up for my weekly webinar! 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 pbrungar Sent: Wednesday, February 06, 2008 3:45 PM To: [email protected] Subject: [Talk] Datastation problem I have a file that ends with an extension of ".rap". The information is delimited with a "*" and the end of line is designated by a "~" When I open the file as delimited, all of the lines are seen as one record by the Datastation. How do I get the Datastation to recongnize the "~" as the end of a record? I found a post on the TALK archives from 2005 that points to using the "D.FileReplace filename, vbCr, vbCrLf" command, but I'm not able to get that to work. Any help would be appreciated. Thanks! Paul Paul Brungardt Clinical Analyst HaysMedicalCenter PH: 785-623-2196 PG: 785-650-5989
