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 thatWebCatalog can read automatically. Look in the docs under File Formats fora description.What I mean is that when WebCatalog thinks a database is quote-commadelimited (basically if the second line begins with a quote), then it willinterpret those 2 quotes in a row as a single quote on a field-by-fieldbasis. It won't do what you want if the data comes in tab-delimited withembedded quotes, though.The only gotcha for Excel is that you *must* make sure all fields arequote-comma delimited. If Excel thinks a column is numeric, it will oftenleave the quotes off, which is a no-no. So you need to get your vendors toforce those columns to be alphabetic in Excel, even if they only containnumbers.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/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 thatWebCatalog can read automatically. Look in the docs under File Formats fora description.What I mean is that when WebCatalog thinks a database is quote-commadelimited (basically if the second line begins with a quote), then it willinterpret those 2 quotes in a row as a single quote on a field-by-fieldbasis. It won't do what you want if the data comes in tab-delimited withembedded quotes, though.The only gotcha for Excel is that you *must* make sure all fields arequote-comma delimited. If Excel thinks a column is numeric, it will oftenleave the quotes off, which is a no-no. So you need to get your vendors toforce those columns to be alphabetic in Excel, even if they only containnumbers.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/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:
database freeze (1997)
Bad Words Filter (2005)
Practice runs ? (1997)
Hyperlink in email (2002)
New Plug-in and Type 11 errors (1997)
unsubscribe (1999)
Math Bug - more testing (1999)
Suggestions on best way to work with yyyy/mm/dd (1997)
Emailer setup (1997)
page redirect in webDNA (1997)
Search Context Strips URL chrs.? (1999)
Problems passing [SKU] with $Replace in 2.0 (1997)
Looping control (1997)
Invisible file issue now a real 'bug' (1999)
SQL statements (2002)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] png support in webDNA (2011)
Line Endings (2007)
Summing fields (1997)
[WebDNA] Error: Can't open order file. Ignoring [OrderFile] context Error: Error: expected [/APPLICATION], but found [/!] instead[/!] (2011)