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 tohave it in web catalog.We have about 100 Nursery growers that upload their available inventoryinto our system. Most of them use MS excel. So we have smart-quoteproblems.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 ofrecords that contain a comma or so I could do a search that finds allrecords that contain , and write something like [replacedb=[db]&sku=[sku]] [showif [field]^,] [GetChars start=2][field][/getchars]and so on for all fields (with the field being replaced as is for fieldsthat don't contain or ,and then [replace db=[db]&sku=[sku]] [GetCharsfrom=end&start=2][field][/getchars][/getChars]and so on to chomp off theback 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 andreplace 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 afile. I can't get 100 clients to switch from excel to filemaker.ThanksTimTim TaylorWebmasterhttp://www.growzone.comTim@versa.comt h e s i t e f o r t h eg r e e n i n d u s t r y1.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 tohave it in web catalog.We have about 100 Nursery growers that upload their available inventoryinto our system. Most of them use MS excel. So we have smart-quoteproblems.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 ofrecords that contain a comma or so I could do a search that finds allrecords that contain , and write something like [replacedb=[db]&sku=[sku]] [showif [field]^,] [GetChars start=2][field][/getchars]and so on for all fields (with the field being replaced as is for fieldsthat don't contain or ,and then [replace db=[db]&sku=[sku]] [GetCharsfrom=end&start=2][field][/getchars][/getChars]and so on to chomp off theback 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 andreplace 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 afile. I can't get 100 clients to switch from excel to filemaker.ThanksTimTim TaylorWebmasterhttp://www.growzone.comTim@versa.comt h e s i t e f o r t h eg r e e n i n d u s t r y1.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:
Join us at MacWorld! (1998)
syntax for contains a word (2002)
Multiple prices (1997)
[countWords]? (1997)
Install webcat on intel/linux box. (2000)
WCS Newbie question (1997)
Java in [object] context requires MRJ 2.2 MacOS (2000)
Merchant and WebCat 3.0 (1998)
[WebDNA] multi-language sites in current versions of webdna? (2010)
Re:Signal Raised (1997)
[Listfiles] vs Netfinder (1997)
PIXO (1997)
[OT] Friday Time Waster (2003)
WC2b15 File Corruption (1997)
& in Lookups (1997)
Replace Statement (1997)
question: webdelivery folder and file (1997)
webcat feature request (1997)
FW: 2.01 upgrade problems (1997)
cookies and [returnraw] (1997)