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:

Date problems (1997) with Link i need to (1997) Re:quit command on NT (1997) WCS Newbie question (1997) Admin Edit prob. (1997) Warning: Mac OS X 10.2.4 Update Overwrites Apache'shttpd.conf (2003) php vs WebCatalog (2000) Exclamation point (1997) [lookup] again... *solved* (2003) zzounds.com. Was: ANN: Strategic Partnership with BuyStream Announced. (2000) Warning: 50 [MATH] Variable Limit per page (1998) Authenticate (1997) Public beta 5 of WebCatalog 4.0 is now available (2000) Pithy questions on webcommerce & siteedit (1997) WebCat2b15MacPlugin - showing [math] (1997) Obscure Question of the day (1997) Grant, please help me ... (1997) [url] (1997) Authenticate (1997) [WebDNA] Digest from talk@webdna.us (2009)