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:
Running _every_ page through WebCat-error.html (1997)
OT: UK DNA Host/PHP developer required (2008)
WebCat editing, SiteGuard & SiteEdit (1997)
Authenticating users without dialog box (1997)
Summing fields (1997)
Date format question (1998)
Security hole in WebCat? (1999)
WebCat2b12 - nesting [tags] (1997)
[WebDNA] Domain upgrade questions (2009)
Setting up shop (1997)
Loops in increments of .25 (2002)
[Webcat 2]Next (1997)
Access Denied! But why? (1997)
Hiding a subsection of text (2002)
Help! WebMerchant store suddenly won't process orders... (2001)
Resolving variables into field names-resolved! (1998)
Email encryption (1998)
IE-caching (1998)
WebCat2 - many [carts] on one template page? (1997)
Question about replacing words (1998)