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:
| |
- Re: writefile, csv, tab and excel import behavior ( Sal D'Anna 2004)
- Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
- Re: writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
- Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
- 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:
Hosting Options (2000)
Some Questions (1997)
[WebDNA] for a rainy day.. if ever/when the hood is up again on the [function]/[return] code (2011)
The Guru Speaks-very long reply (1998)
Too Much Rootbeer Free Offer (1997)
Another question (1997)
A little syntax help (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
formula's (1998)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
Interesting speed comparison .. (2003)
[ShowNext] feature in 2.0 (1997)
New NT betas available (1997)
SKU (1997)
triggers.db (1999)
[WebDNA] Error 500 with SUMM=T (2017)
Online CC Processing (2002)
problems with 2 tags (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
Configuring E-mail (1997)