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

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59066
interpreted = N
texte = Make sure there's a carriage return after the last line. I've seen this before. It's worth spending the extra effort to insert the last CR automatically if you have some sort of import routine. Even better to write out a last reocrd with a special SKU/ID that you search for, verify, then delete just to make sure. >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/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- 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:

    
  1. Re: Webcat deletes last line from Excel-saved text db ( Gary Krockover 2004)
  2. Re: Webcat deletes last line from Excel-saved text db ( John Hill 2004)
  3. Re: Webcat deletes last line from Excel-saved text db ( John Hill 2004)
  4. Re: Webcat deletes last line from Excel-saved text db ( Gary Krockover 2004)
  5. Webcat deletes last line from Excel-saved text db ( John Bennett 2004)
Make sure there's a carriage return after the last line. I've seen this before. It's worth spending the extra effort to insert the last CR automatically if you have some sort of import routine. Even better to write out a last reocrd with a special SKU/ID that you search for, verify, then delete just to make sure. >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/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- 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/ John Hill

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

payment processors (2005) PCS Frames (1997) Request for page test (2003) TCPSend/Replace DB Records (2002) [WebDNA] a major shift in strategy? (2008) Formatting (2000) [WebDNA] Off topic: ImageMagick (2008) no time stamp & different times from emailer (1998) $Replace with [founditems] (1997) Validation (2000) Q on the best way to set up a security function so users canedit records (1999) SQL / Webcat Help (1999) Grepping spaces (2004) search function (2005) [SMSI] WebDNA is too good to go away! (2006) Size limit for tmpl editor ? (1997) Virtual hosting and webcatNT (1997) Field name-subcategory (1997) How do I pass [cart] when user clicks back (2000) Stopping bad HTML propagation ? (1997)