Re: Exporting from Excel
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21893
interpreted = N
texte = You gotta hate Excel. I've had the same weirdness It won't stop using quotes for text fields. You can try to set the cells to general, text or number format, and It keeps firing quotes into the mix.I have always had to open the file in BBEdit or Word and replace \t with \tThat means replace each quote-tab-quote sequence with just a tab.Excel also chokes on large files. If you're trying to modify a field by creating a new column and inserting a formula, Excel will arbitrarily cease to calculate or even respond to a 'force calculation' command.I have wasted untold hours coping with these 'quirks'. They exist on Excel for windows and the Mac but behave slightly differently.If you can use Access, Filemaker, Microsoft Works or ClarisWorks on either platform, you can write translation scripts to handle repetitive conversions. Database programs all tend to be more literal when handling characters in fields.You have been spoiled by the perfection WebCat exhibits in handling fields literally, so it's always a shock to see how sloppy the more famous applications actually are.Pat----- Original Message ----- From:
To: Sent: Tuesday, December 15, 1998 6:57 PM Subject: Exporting from Excel >I remember seeing some posts on this in the past but I can not find them in >the talk list. > >Anyway, I am having a terrible time exporting a tab separated text file >from excel 97. I get weird line breaks and quotations. Does anyone have >any advice for getting a clean export? > >Thanks, > >Josh >--------------------------------------------------------------------------- >Joshua Blank Pop Art LLC http://pop-art.com >josh@pop-art.com eCommerce / Web Design / Multimedia > >7000 SW Hampton St. tel: (503) 968.5957 >Suite 124 fax: (503) 620.8487 >Portland, OR 97223-8361 > > > >
Associated Messages, from the most recent to the oldest:
You gotta hate Excel. I've had the same weirdness It won't stop using quotes for text fields. You can try to set the cells to general, text or number format, and It keeps firing quotes into the mix.I have always had to open the file in BBEdit or Word and replace \t with \tThat means replace each quote-tab-quote sequence with just a tab.Excel also chokes on large files. If you're trying to modify a field by creating a new column and inserting a formula, Excel will arbitrarily cease to calculate or even respond to a 'force calculation' command.I have wasted untold hours coping with these 'quirks'. They exist on Excel for windows and the Mac but behave slightly differently.If you can use Access, Filemaker, Microsoft Works or ClarisWorks on either platform, you can write translation scripts to handle repetitive conversions. Database programs all tend to be more literal when handling characters in fields.You have been spoiled by the perfection WebCat exhibits in handling fields literally, so it's always a shock to see how sloppy the more famous applications actually are.Pat----- Original Message ----- From: To: Sent: Tuesday, December 15, 1998 6:57 PM Subject: Exporting from Excel >I remember seeing some posts on this in the past but I can not find them in >the Talk List. > >Anyway, I am having a terrible time exporting a tab separated text file >from excel 97. I get weird line breaks and quotations. Does anyone have >any advice for getting a clean export? > >Thanks, > >Josh >--------------------------------------------------------------------------- >Joshua Blank Pop Art LLC http://pop-art.com >josh@pop-art.com eCommerce / Web Design / Multimedia > >7000 SW Hampton St. tel: (503) 968.5957 >Suite 124 fax: (503) 620.8487 >Portland, OR 97223-8361 > > > >
Pat McCormick
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:
international time (1997)
WebCatalog2 Feature Feedback (1996)
I give up!! (1997)
Which Pref is faster? (1998)
Three new problems, maybe a fourth (1997)
UPS Rates (2006)
Authenticate (1997)
[addlineitems] (1997)
[WebDNA] New Webdna framework - WebDNACodeSparker (2012)
WebCatalog2 Feature Feedback (1996)
[WebDNA] Facebook Application - Custom Tab for Fan / Non-Fan (2011)
How can I Add several Items into the cart at once? (1997)
Help Wanted - Stowe, Vermont (1999)
How To question on setting up downloads (1997)
RE: [WebDNA] Crashing (2008)
formatting a number (1999)
Comments in db? (1997)
WebCat2 - [format thousands] (1997)
Upgrade to wsV (Email issue) (2004)
WebCat2.0b15-to many nested [xx] tags (1997)