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:
PIXO (1997)
Math Blind (2000)
Support ?? (1997)
Order not created error (never mind) (1997)
Version 4? (2000)
sort problems....bug or brain fart? (1997)
question: back button prevention (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
Automatic installation of WebDNA by hosting clients? (2005)
Merging databases (1997)
AOL and referrers on target=_blank (2000)
RE: PIXO support (1997)
RE: Cart Template (1997)
WebCatalog can't find database (1997)
emailer (1997)
Re:quit command on NT (1997)
attn: smitmicro - cart limitation (2002)
[REQ] Improved SQL context (2000)
Need relative path explanation (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)