writefile, csv, tab and excel import behavior

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58221
interpreted = N
texte = How would one use writefile to export a tab delimited file or csv so that excel plays nice. Currently I can export using: "value1","value2","value3" Except excel formats some of the values and numeric and tries to evaluate them. I was going to try a tab delimited format such as: [unurl][fieldname1]%09[fieldname2]%09[fieldname3][/unurl] Any ideas??? TIA! Vince ------------------------------------------------------------- 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: writefile, csv, tab and excel import behavior ( Sal D'Anna 2004)
  2. Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
  3. Re: writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
  4. Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
  5. writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
How would one use writefile to export a tab delimited file or csv so that excel plays nice. Currently I can export using: "value1","value2","value3" Except excel formats some of the values and numeric and tries to evaluate them. I was going to try a tab delimited format such as: [unurl][fieldname1]%09[fieldname2]%09[fieldname3][/unurl] Any ideas??? TIA! Vince ------------------------------------------------------------- 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/ "Vincent Medina"

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:

searches with dash, period etc. (2000) Wireless WebDNA available today! (2000) Database Structure? (1998) dates and hex formatting (1997) rotating thumbnails (1997) [WebDNA] Ubuntu 16.04.4 LTS (2018) [OT] Happy Turkey Day! (2003) log out (2001) About Cookies... (2004) Problems searching from a FORM (1997) cart (1997) Emailer setup (1997) Search Debugging (2004) HTML Editors (1997) same product in cart (1997) Virtual hosting and webcatNT (1997) PCS Customer submissions ? (1997) Extracting a Word (2000) WebCatalog/Mac 2.1b2 - PIXO (1997) TEXT Variable (2003)