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:
SSL and reg web*L and reg web* (1997)
Database flushing does not work any more... (2000)
Possible Bug in 2.0b15.acgi (1997)
Sorting alphabetical (2003)
passing search criteria (1997)
Sorting Numbers (1997)
(2000)
Max Record length restated as maybe bug (1997)
More Applescript (1997)
help with autenticate (1998)
2.0 Info (1997)
RAM variables (1997)
Practice runs ? (1997)
WebCat2: multiple currency support (1997)
Is [thisurl] http or https? (1998)
Multiple prices (1997)
no [search] with NT (1997)
Copyright that puppy (1998)
Dealer Locator (zip codes) (2003)
TRAINING videos - Prove IT. (1998)