I need a Smart-quote workaround
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23017
interpreted = N
texte = Hi all, I redesigning a system that we have up in tango, but I would prefer to have it in web catalog. 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. Now most of the time they are just placed at the begining and end of records that contain a comma or so I could do a search that finds all records that contain , and write something like [replace db=[db]&sku=[sku]] [showif [field]^,] [GetChars start=2][field][/getchars] and so on for all fields (with the field being replaced as is for fields that don't contain or , and then [replace db=[db]&sku=[sku]] [GetChars from=end&start=2][field][/getchars][/getChars]and so on to chomp off the back smart quote.Except they are not just on the ends, they also place one after the which occurs in almost every record.Now normally what I would do is open the file in bbedit find and replace with `` then find and delete it then find`` and replace with . Can anyone think of a way to get web cat to perform that sequence on a file. I can't get 100 clients to switch from excel to filemaker.ThanksTimTim Taylor Webmaster http://www.growzone.com Tim@versa.com t h e s i t e f o r t h e g r e e n i n d u s t r y 1.888.800.5904
Associated Messages, from the most recent to the oldest:
Hi all, I redesigning a system that we have up in tango, but I would prefer to have it in web catalog. 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. Now most of the time they are just placed at the begining and end of records that contain a comma or so I could do a search that finds all records that contain , and write something like [replace db=[db]&sku=[sku]] [showif [field]^,] [GetChars start=2][field][/getchars] and so on for all fields (with the field being replaced as is for fields that don't contain or , and then [replace db=[db]&sku=[sku]] [GetChars from=end&start=2][field][/getchars][/getChars]and so on to chomp off the back smart quote.Except they are not just on the ends, they also place one after the which occurs in almost every record.Now normally what I would do is open the file in bbedit find and replace with `` then find and delete it then find`` and replace with . Can anyone think of a way to get web cat to perform that sequence on a file. I can't get 100 clients to switch from excel to filemaker.ThanksTimTim Taylor Webmaster http://www.growzone.com Tim@versa.com t h e s i t e f o r t h e g r e e n i n d u s t r y 1.888.800.5904
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:
PSC recommends what date format yr 2000??? (1997)
Showif, Hideif reverse logic ? (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
Running _every_ page through WebCat-error.html (1997)
WebCat2b15MacPlugin - showing [math] (1997)
problems with 2 tags (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
displaying New products (using [date]) (1997)
Looking for WebSTAR bomb at startup (2000)
WebCatalog2 Feature Feedback (1996)
PIXO support (1997)
Finding max value for a field (1997)
Include an include file as raw webDNA (2002)
Error Lob.db records error message not name (1997)
Bug in 4.5 - Needs to be fixed ASAP. (2002)
b12 cannot limit records returned and more. (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
[WebDNA] Hard-coded db write delay when running certain code? (2011)
Help! WebCat2 bug (1997)
Possible Bug in 2.0b15.acgi (1997)