When looking at the file with the "EOF" character in a hex editor, each record ends with 0D 0A and the last line ends with 0D 0A 1A. A file without the "EOF" character, the last lines ends with 0D 0A.
Ted -----Original Message----- From: van der Zwaag, Frank [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 6:48 PM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: SET EOFCHAR OFF Good point. I have seen this funny character at the end of a file as well. Let's take a step back and think about this: If the file that we created opens with notepad or word or whatever, than there must be an EOF mark at the end of the file, as with any other file, being that a word doc, spreadsheet or database. The character that we see at the end of the file is either a duplicate EOF character, which can't be as the next one wouldn't have be shown, or it is some spurious character that we call EOF. I suggest that someone has a look with hexeditor and finds out what really is inserted at the end of the file prior to the official EOF mark. Once we know what it is we can find ways of getting rid of it. Frank -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jim Limburg Sent: Friday, 30 April 2004 08:36 To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: SET EOFCHAR OFF Ted A long shot here, I wonder if it has to do anything with the charater set. Maybe notepad/windows is reading a char rbase is putting in as something else. I know there are some people on this list that know more about this than I do, I have never tinkered in this area. Just a thought. Jim Ted Wolfley wrote: Hi, Wrap is off. The difference in the files depends if the EOFCHAR is either on or off. I guess I'll just have to delete the EOF character manually. Ted -----Original Message----- From: Jim Limburg [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, April 29, 2004 3:09 PM To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Subject: [RBASE-L] - Re: SET EOFCHAR OFF The new versions of notepad for W2k and XP automatically wrap.. You have to go to the format menu and uncheck wrap. What's a pain is it doesn't always remember this setting if I remember right, or it may be it only remembers is with same file that it has opened.. can't recall at moment.. Jim Ted Wolfley wrote: Hi, Using both 6.5++ and 7. Opening in Notepad is where we notice the difference, two other text editors show no wrapping. I am creating a empty file with the SET OUTPUT filename and using a cursor with a while loop to append data that is in a variable with a write command. In the loop, data of each record is added to the variable using the sput function to create the correct column widths, append variable to file, fetch new record. I've tried placing the SET EOFCHAR OFF inside the loop but have the same results. Ted -----Original Message----- From: Jim Limburg [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] Sent: Thursday, April 29, 2004 9:34 AM To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Subject: [RBASE-L] - Re: SET EOFCHAR OFF Ted 1. What version of RBase are you using ?? Win - Dos ?? 2. What are you opening the file in after it is created? Some text readers wrap even if you don't wan't them to. Try opening it in Notepad and set wordwrap off. 3. Are you sending this info out through a report, or a standard SET OUTPUT filename? If you going through a report then you'll have to set the page to landscape and the paper to legal or maybe something longer depending on info length. 4. You comments make me think you are sending the info through a report, so here is what I suggest.. Based on Win65++, Create a new printer -- depending on operating system the steps might be different ... Create a "Generic / Text Only" printer -- this willl be in the list of manufacturers. Set the settings for this printer to be landscape and paper to be legal as the default selections. Then use PRNSETUP and change to this printer before you start the report and see what your results are. Jim Ted Wolfley wrote: Hi, I am trying to create a fixed width text file that has a header and detail section without a end-of-file character. With SET EOFCHAR ON, the file is created correctly except for the end-of-file character at the bottom. With SET EOFCHAR OFF, the file looks like it has word-wrap on with each record covering multiple lines. The record line length is 962. Ted Wolfley Database/Internet Programmer The Ogden Group of Rochester phone: (585) 321 1060 x23 fax: (585) 321 0043 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> www.ogdengroup.com <http://www.ogdengroup.com> <http://www.ogdengroup.com/> <http://www.ogdengroup.com/> ____________________________________________________________________ CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Air New Zealand immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Air New Zealand. _____________________________________________________________________ For more information on the Air New Zealand Group, visit us online at http://www.airnewzealand.com _____________________________________________________________________ --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
