Re: Webcat deletes last line from Excel-saved text db

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 59056
interpreted = N
texte = You must have a carriage-return at the end of the db file, so my guess is webcat is going back to the last return, which would be the beginning of your last line of the Excel file.FWIW, I *never* save my files from Excel. You have Microsoft "smart-quoting" to deal with and other issues, like the one you've found. Perhaps Mac Office doesn't "smart quote" - I don't recall.What I do is work up the data in Excel, then select the entire sheet, copy and paste it into a plain text editor, BBEdit would be good in your case. Tabular formatting will be preserved and you don't have any funny business added by the save procedure from Excel.GKAt 04:14 PM 8/14/2004, you wrote:>Hey->>I've found that when I save a db in excel's tab delimited text (Mac Excel >98) format that webcat chops off the last entry ( and leaves a blank line >in its place). This will continue with every Excel save and Webcat open.>> I've opened the Exel-saved db in a text editor and it looks normal, with > no funny characters at the end, just a carriage return.>>Anyone experience this problem?>>Thanks,>john-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Webcat deletes last line from Excel-saved text db ( Gary Krockover 2004)
Re: Webcat deletes last line from Excel-saved text db ( John Hill 2004)
Re: Webcat deletes last line from Excel-saved text db ( John Hill 2004)
Re: Webcat deletes last line from Excel-saved text db ( Gary Krockover 2004)
Webcat deletes last line from Excel-saved text db ( John Bennett 2004)

You must have a carriage-return at the end of the db file, so my guess is webcat is going back to the last return, which would be the beginning of your last line of the Excel file.FWIW, I *never* save my files from Excel. You have Microsoft "smart-quoting" to deal with and other issues, like the one you've found. Perhaps Mac Office doesn't "smart quote" - I don't recall.What I do is work up the data in Excel, then select the entire sheet, copy and paste it into a plain text editor, BBEdit would be good in your case. Tabular formatting will be preserved and you don't have any funny business added by the save procedure from Excel.GKAt 04:14 PM 8/14/2004, you wrote:>Hey->>I've found that when I save a db in excel's tab delimited text (Mac Excel >98) format that webcat chops off the last entry ( and leaves a blank line >in its place). This will continue with every Excel save and Webcat open.>> I've opened the Exel-saved db in a text editor and it looks normal, with > no funny characters at the end, just a carriage return.>>Anyone experience this problem?>>Thanks,>john-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Gary Krockover

DOWNLOAD WEBDNA NOW!

Re: Webcat deletes last line from Excel-saved text db

2004

Top Articles:

Related Readings: