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:
Replace Statement (1997)
[include] affect on filepaths for links? (1997)
Shownext problems (1999)
Emailer 1.0.2 Conflicts? (1998)
[WebDNA] WebSite Examples (2008)
UPS Shipping (1999)
[WebDNA] Admin Login Required to Serve any TPL Page (2009)
Triggers or No Triggers? (1999)
PCS Emailer's role ? (1997)
Multiple fields on 1 input (1997)
Shared conversion under WebTen (1998)
Newbie Tax Question (1997)
placement of ? (2000)
How to Sort Summ data ? (1997)
Formulas.db + Users.db (1997)
Assigning Serialized Customer Numbers (1997)
Quit revisited (1997)
Extended [ConvertChars] (1997)
Bug Report, maybe (1997)
.. more on sliding discounts... (1997)