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:

WebCatalog for Postcards ? (1997) Stop the madness. (1997) Formatting a .txt file (1998) Country & Ship-to address & other fields ? (1997) [addlineitems] as oppossed to url command=add (2000) enhanced ErrorMessages.db (2002) New Plug-in and Type 11 errors (1997) multiple search commands (1997) Intermitent problem using [referrer] (1997) [protect admin] (1997) Not really WebCat (1997) Trouble with formula.db (1997) all records returned. (1997) Setting up shop (1997) Nested search (1997) Caching problem... (2000) Browser Reloads and AddlineItem (1997) WebCat b15 Mac plug-in (1997) Ampersand Character (&) (1997) Caching [include] files ... (1997)