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:
WebCat2b12 - nesting [tags] (1997)
shell problem (2003)
Webten + Webcat running smooth (1998)
F3 crashing server (1997)
[WebDNA] [listwords] and [index] (2009)
Line ending nuisance (2005)
popups, netscape vs explorer (1997)
Don't tick me off :) [elaspedtime] (1997)
Adding up weights (1998)
WebCatalog can't find database (1997)
MacAuthorize order data fields WAS:How To question... (1997)
Re:2nd WebCatalog2 Feature Request (1996)
RE: [WebDNA] Sending 100 mails an hour then pausing (2010)
Cookie again (1999)
WebCat2b15MacPlugin - showing [math] (1997)
pacific-coast or starnine? (1998)
Multiple catalog databases and showcart (1997)
Robert Minor duplicate mail (1997)
Search for 20 finds ... Eureka! (1997)
syntax question, not in online refernce (1997)