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:
attachment (2000)
question: Eudora 3.1.1 (1997)
Need help... (1997)
WebCat2b13 Command Reference Doc error (1997)
[BULK] [WebDNA] [BULK] which of these tags exist in 7.0 (2011)
WebCat2final1 crashes (1997)
Order not created error (1997)
Date problems-more (1997)
Unexpected comparison behavior change in 4.5.1 (2003)
Missing custom convert.db (1998)
WebCatalog can't find database (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Hiding Email Addresses (2003)
[BULK] [WebDNA] Can WebDNA corrupt a db? (2012)
WCS Newbie question (1997)
Where is f2? (1997)
Multiple cart additions (1997)
Mac v. NT (1998)
[WebDNA] Sorry WebDNA server not running (2014)
[carts] and databases (1997)