Re: I need a Smart-quote workaround
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23030
interpreted = N
texte = It wen't.... >>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. I see you mean as quote-comma delimited from the on-line docs but I'm haveing trouble getting excel to place quotes around every field Excel lists its save options as formatted text (tab delimited) text(space delimited) and CSV(comma delimited) CSV(windows) The comma deliniated won't insert the quotes all by itself. How do you force those columns to be alphabetic in Excel?
Associated Messages, from the most recent to the oldest:
It wen't.... >>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. I see you mean as quote-comma delimited from the on-line docs but I'm haveing trouble getting excel to place quotes around every field Excel lists its save options as formatted text (tab delimited) text(space delimited) and CSV(comma delimited) CSV(windows) The comma deliniated won't insert the quotes all by itself. How do you force those columns to be alphabetic in Excel?
Tim Taylor
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:
bug in [SendMail] (1997)
problems with WebCat-Plugin ()
Mac app. that converts e-mails (2000)
Database wiped clean (2005)
Finding max value for a field (1997)
using showpage and showcart commands (1996)
List Address Changed! (1998)
small job/demo setup (1999)
WebDNA Solutions ... (1997)
WebCatalog security on NT (2000)
Delete context run amok (2005)
RE: [setcookie] & [redirect] (1998)
[foundItems] context question --returns some fields but n (2000)
Emailer help....! (1997)
[shownext] (1999)
learning PHP (2007)
WCS Newbie question (1997)
Show if time tags (1997)
Solve the Problem, get the code! (2001)
Emailer error 571 (1998)