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:
WebMerch/Emailer Error (1998)
[Sum] function? (1997)
Help formatting search results w/ table (1997)
Help formatting search results w/ table (1997)
WebCat hosting providers? (1997)
Comments in db? (1997)
Opinion: [input] should be called [output] ... (1997)
orderfile headers (was: 2nd Request for help/adviceonvariable pricing) (2000)
Using & in subject line (2003)
about this server and links to who (1997)
Behind the Scenes. . . (1998)
Ends With (2003)
2.1 Stuff (1998)
Includeform Error (2002)
[WebDNA] WebDNA code validator (2011)
getting images' width/height (1998)
Hard Questions ? (1997)
WebCatalog can't find database (1997)
Yet another db manager (2004)
Deleting Orders (1997)