-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Carroll Sent: Saturday, March 11, 2006 8:45 AM To: [email protected] Subject: Re: tab delimited text & excel, RB 5.5.5
Thanks Tom and Joe for your replies. Just checking the last bit of the existing file would be preferable to reading the entire file. This is eventually going to be a list of registration info for demo users of my application. At the moment its just a few lines for testing, but it will accumulate to a fairly large file. >> If you exercise total control ofver the origbinal files creation >> though, your best bet is to make sure it goes out with an EndOfLine >> character appended to it. I don't have any problem when the file is only being manipulated by my own realbasic code. Right now, I have a small application that looks through email on my machine, collects the relevant emails, parses out form submission data from them and then write these as lines of tab separated text appended to the existing file. The problem begins when the resulting file is opened and edited in Excel. The text file opens as a spreadsheet as expected, each line of text as a row on the sheet. Inserting/deleting rows or editing cell contents seems to delete the endofline so that the next attempt to append to the same file often extends the last line, instead of starting a new one. If I open the text file in Word, at least I can set it to show the invisible characters, and see whether the line break has been deleted or not. But I would rather avoid yet another step in the file manipulation. Is there possibly a more reliable file format for this type of record? thanks Rob On Mar 11, 2006, at 12:44 AM, realbasic-nug- [EMAIL PROTECTED] wrote: > From: Tom Benson <[EMAIL PROTECTED]> > Date: Sat, 11 Mar 2006 13:48:40 +1100 > > You could try > > if right(textInputStream.Readall,1) = EndOfLine then > > If you exercise total control ofver the origbinal files creation > though, your best bet is to make sure it goes out with an EndOfLine > character appended to it. > > Cheers, > Tom > > > Subject: Re: tab delimited text & excel, RB 5.5.5 > From: "Joseph J. Strout" <[EMAIL PROTECTED]> > Date: Fri, 10 Mar 2006 20:16:52 -0700 > > > Better make that Right(TextInputStream.ReadAll, EndOfLine.Len) > instead; you shouldn't assume that EndOfLine is a single character. > > And of course, it's a bit inefficient to read the whole file just to > check the last character or two. Better might be something like > (assuming tis is your TextInputStream, and f is the file it was opened > from): > > tis.Position = f.Length - EndOfLine.Len > if tis.Read( EndOfLine.Line ) = EndOfLine then > > Same idea, just skips some extra reading. > > HTH, > - Joe > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
