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:

WC2b15 File Corruption (1997) Showif, Hideif reverse logic ? (1997) Fun with dates (1997) OS X permissions to write to Globals directory (2003) No Subject (1998) Max Include levels (2000) WebCatalog2 Feature Feedback (1996) Maybe off topic but how to charge (1997) [WebDNA] Help with iTools 9/WebDNA setup MacTel (2009) [WebDNA] Multiple e-mail sending (2011) Checking for @ sign (2006) Freeze (2003) Q on the best way to set up a security function so users can edit records (1999) Multiply prices (1997) Re[2]: shipCost -vs- shippingtotal ? (2000) [writefile] (1997) WebMerchant and PCAuthorize (1998) Formulas.db + Users.db (1997) bug in [SendMail] (1997) yourpay.com (2004)