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:
Cleaning up all the shopping carts (2000)
[searchString] (1997)
Re2: frames & carts (1997)
Grep Question (2003)
Add to Cart & List of Products (1997)
listfiles, moving files (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Showif for mulitple variations (1997)
Here's how to kill a Butler Database. (1997)
db protection on NT (1997)
Document contains no data... (1999)
WebCat2b13 Command Reference Doc error (1997)
[WebDNA] Issue with [table] append and search from, ... (2016)
[WebDNA] Testing (2016)
Hiding HTML and breaking the page (1997)
F3 crashing server (1997)
[WebDNA] HTML/OS vs. WebDNA ? (2008)
Public Beta for WebCatalog 4.0 is Available (2000)
japanese characters (1997)
problem: search crashes webstar (1997)