Re: I need a Smart-quote workaround
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23024
interpreted = N
texte = >We have about 100 Nursery growers that upload their available inventory >into our system. Most of them use MS excel. So we have smart-quote >problems. >ie.. 42B&B becomes 42B&B and2+ cal. becomes 2+Cal.This looks an awful lot like the quote-comma delimited Merge format that WebCatalog can read automatically. Look in the docs under File Formats for a description.What I mean is that when WebCatalog thinks a database is quote-comma delimited (basically if the second line begins with a quote), then it will interpret those 2 quotes in a row as a single quote on a field-by-field basis. It won't do what you want if the data comes in tab-delimited with embedded quotes, though.The only gotcha for Excel is that you *must* make sure all fields are quote-comma delimited. If Excel thinks a column is numeric, it will often leave the quotes off, which is a no-no. So you need to get your vendors to force those columns to be alphabetic in Excel, even if they only contain numbers.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>We have about 100 Nursery growers that upload their available inventory >into our system. Most of them use MS excel. So we have smart-quote >problems. >ie.. 42B&B becomes 42B&B and2+ cal. becomes 2+Cal.This looks an awful lot like the quote-comma delimited Merge format that WebCatalog can read automatically. Look in the docs under File Formats for a description.What I mean is that when WebCatalog thinks a database is quote-comma delimited (basically if the second line begins with a quote), then it will interpret those 2 quotes in a row as a single quote on a field-by-field basis. It won't do what you want if the data comes in tab-delimited with embedded quotes, though.The only gotcha for Excel is that you *must* make sure all fields are quote-comma delimited. If Excel thinks a column is numeric, it will often leave the quotes off, which is a no-no. So you need to get your vendors to force those columns to be alphabetic in Excel, even if they only contain numbers.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Another question (1997)
Calendar Snippet (1998)
Sorting by date (1997)
Hiding HTML and breaking the page (1997)
Test (2003)
RE: Automatic thumbnail images (1998)
WebCat/CyberStudio Compatibility (1998)
Failed SQL Query (2005)
Trigger time setting (2002)
Formulas.db not working (2006)
Forms Search Questions (1997)
Help name our technology! I found it (1997)
[WebDNA] Copy a whole row from a db to another db or table (2017)
Review comparison by PC Magazine: Open for On-line Business (1997)
searching a range (2000)
Disappearing Databases (2000)
Date Sorting (1997)
Only charge card when product shipped ? (1997)
AppleScript question (1997)
[convertchars] limits (1998)