Karen that removes the end of file character but not the carrage return line feed.
Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 8/19/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Re: Last carriage return removal > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, August 19, 2008, 1:44 PM > I thought the proper syntax was SET EOFCHAR OFF > > Karen > > > > I have a text file I am creating with the following: > > > > GATEWAY EXPORT CSV .v850file + > > SELECT edidata FROM edisplit + > > WHERE storenumber = 'All' OR location IN > &vlocation + > > OPTION MESSAGES ON + > > |SHOW_PROGRESS ON + > > |QUALIFIER &vQualifier > > > > -- turn off eof setting > > set eof off > > > > -- write the GE and IEA records > > OUTPUT .v850file APPEND > > WRITE .vchar > > WRITE .vge > > WRITE .viea > > OUTPUT SCREEN > > > > > > Which works like I need except there is a carriage > return at the end of the > > file. > > The customer will not accept the file with it ending > with a carriage > > return. I have > > spent 2 hours trying to get this seemingly simple > issue resolved and now I > > am frustrated. > > > > Any ideas on how to end a file without a carriage > return? > >
