That did the trick. Thanks for your help. Stephen
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C. Blackwell Sent: Thursday, April 12, 2007 1:14 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] Datastation Problems Greetings, I concur with Billy. Use Fixed length and when setting up the field lengths - just click at the start of the field. In your case, you'd just have one. For style points, use the Field Rename feature because your field name will look like: @1,80 or similar. To remove the extra white space you can set: d.Trim = True right after our d.Open command. This tells the DataStation to remove any whitespace from fields it is parsing - you will need this or a Trim command around your field - unless the data has a carriage return directly after the last character. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems 866 653 - 5105 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Billy Padilla Sent: Thursday, April 12, 2007 1:04 PM To: [EMAIL PROTECTED] Subject: RE: [Talk] Datastation Problems Stephen, I would try using the fixed length file type. _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen R. Smesny Sent: Thursday, April 12, 2007 11:50 AM To: [EMAIL PROTECTED] Subject: [Talk] Datastation Problems I am trying to open a generic file in datastation. The file is a txt file downloaded from Meditech. The only way I have found to be able to open the file and my records open up properly is to open it as an excel file. If I open the file as a generic file my records do not show up in datastation. The file is formatted as follows: 123456 654321 789654 654789 345976 Each number should be a new record. Is it possible to tweak the .bds file to open this properly as a generic file? The problem is that the PC I will be running this script on does not have excel. So when the script tries to open the file I get a message stating that the machine does not have excel. How do I get this to work without having to install excel? Thanks, Stephen Smesny ********************************************************************** The information contained in this electronic communication, and any electronic attachment(s), is CONFIDENTIAL and is intended only for the named recipient(s) above. If the reader of this message is not the intended recipient(s), you are hereby notified that any release of information or distribution of this communication is prohibited by law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender via reply email and delete this communication. ********************************************************************** This message was scanned with MIMESweeper.
