Ted: The interpretation of the hex codes is as follows: 0D - 13 decimal - Carriage Return 0A - 10 decimal - Line feed 1A - 26 decimal - Substitute (???) It is normal for a line to end with 0A, 0D; however I am not sure what the 1A code is, form fee is normally HEX C or decimal 13. If your file without EOF ends with 0D, 0A then it is what you want. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Wolfley Sent: Friday, April 30, 2004 8:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SET EOFCHAR OFF 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 _____________________________________________________________________
