Re: Unexceling (was I need a smart quote...)
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23151
interpreted = N
texte = I'm not sure if this is exactly what you are looking for, but it might work (well, it would be _really_ slow, but it should work). The theory goes something like this:- Loop through each character of the file (one char. at a time) with [GetChars]. - If the character isn't - Append it to a new file (or a [text] variable in 3.x) - If the character is - Look at the next character - If the next character is - Append to the new file - If the next character isn't - Don't do anythingIn WebDNA (3.x) it would probably look something like this:[Loop start=1&end=[CountChars][include somefile][/CountChars]] [Text]ThisChar=[GetChars start=[index]&end=[index]][include somefile][/GetChars][/Text] [HideIf [ThisChar]=] [AppendFile somenewfile][ThisChar][/AppendFile] [/HideIf] [ShowIf [ThisChar]=] [ShowIf [GetChars start=[math][index]+1[/math]&end=[math][index]+1[/math]][include somefile][/GetChars]=] [AppendFile somenewfile][/AppendFile] [/ShowIf] [/ShowIf] [/Loop]I offer no guarantees; I haven't even tried to run this, but in theory it should do the job. If you're running 2.1, you could make it work by getting rid of the text variable and just doing the [GetChars] in each of the 3 or 4 places it's needed (this will be slower).-DaveAt 2:28 PM 2/1/99, Tim Taylor wrote: > The more I look at this problem the more it seems that I am not going to >be able to find a solution within web-catalog (unless the convert a whole >string [converchars] funtion appears overnight. I just wanted to try to >pick the lists collective brain one more time before I tried to find some >app on the server side to do it instead ( I really think the programing >level for that is going to be beyond me. ) >For those of you that missed it the first time around here is the problem. >I have about 100 growers that upload there current plant stock to our >system. Almost all of them use Ms Excel. I can't get them to change that. >Plant sizes are in inches so... >42B&B becomes 42B&B and2+ cal. becomes 2+Cal. >They need to update their inventory on an almost daily basis and I won't be >able to physically come in and clean everything up before It becomes part >of their catalogs. If their db's were just simple text files I would >normally perform this sequence. > find and replace with `` then find and delete it then find`` >and replace with >I know I've put this question to list before, but I just wanted to >circulate a last call Does anyone know of a way to perform that function >within web cat? Or as an alternative, does anyone know of a way to get >Excel to stop stepping on the Data in this particular way? > >Tim Taylor >Webmaster >http://www.growzone.com >Tim@versa.com >t h e s i t e f o r t h e >g r e e n i n d u s t r y >1.888.800.5904 o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Associated Messages, from the most recent to the oldest:
I'm not sure if this is exactly what you are looking for, but it might work (well, it would be _really_ slow, but it should work). The theory goes something like this:- Loop through each character of the file (one char. at a time) with
[getchars]. - If the character isn't - Append it to a new file (or a
[text] variable in 3.x) - If the character is - Look at the next character - If the next character is - Append to the new file - If the next character isn't - Don't do anythingIn WebDNA (3.x) it would probably look something like this:[Loop start=1&end=
[countchars][include somefile][/CountChars]]
[text]ThisChar=[GetChars start=[index]&end=[index]][include somefile][/GetChars][/Text] [HideIf [ThisChar]=] [AppendFile somenewfile][ThisChar][/AppendFile] [/HideIf] [ShowIf [ThisChar]=] [ShowIf [GetChars start=
[math][index]+1[/math]&end=
[math][index]+1[/math]][include somefile][/GetChars]=] [AppendFile somenewfile][/AppendFile] [/ShowIf] [/ShowIf] [/Loop]I offer no guarantees; I haven't even tried to run this, but in theory it should do the job. If you're running 2.1, you could make it work by getting rid of the text variable and just doing the
[getchars] in each of the 3 or 4 places it's needed (this will be slower).-DaveAt 2:28 PM 2/1/99, Tim Taylor wrote: > The more I look at this problem the more it seems that I am not going to >be able to find a solution within web-catalog (unless the convert a whole >string [converchars] funtion appears overnight. I just wanted to try to >pick the lists collective brain one more time before I tried to find some >app on the server side to do it instead ( I really think the programing >level for that is going to be beyond me. ) >For those of you that missed it the first time around here is the problem. >I have about 100 growers that upload there current plant stock to our >system. Almost all of them use Ms Excel. I can't get them to change that. >Plant sizes are in inches so... >42B&B becomes 42B&B and2+ cal. becomes 2+Cal. >They need to update their inventory on an almost daily basis and I won't be >able to physically come in and clean everything up before It becomes part >of their catalogs. If their db's were just simple text files I would >normally perform this sequence. > find and replace with `` then find and delete it then find`` >and replace with >I know I've put this question to list before, but I just wanted to >circulate a last call Does anyone know of a way to perform that function >within web cat? Or as an alternative, does anyone know of a way to get >Excel to stop stepping on the Data in this particular way? > >Tim Taylor >Webmaster >http://www.growzone.com >Tim@versa.com >t h e s i t e f o r t h e >g r e e n i n d u s t r y >1.888.800.5904 o--------------- Dave MacLeay --+ o----------- Digital Frontier --+ o--------------- 802.253.8612 --+ o--- dave@digitalfrontier.com --+
Dave MacLeay
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:
Search returns all, not 20 (1997)
Dropdown menus (2006)
Multiple Pulldowns (1997)
Frames and WebCat (1997)
Simultaneous Users (1999)
turning every 5th line red (1999)
Out of the woodwork (2007)
[ot] ShowIf & HideIf Question (1998)
Re:quit command on NT (1997)
Searching for foreign chars (2004)
Speed Optimization - Mac (1997)
WebCat2b12 - nesting [tags] (1997)
Need help with emailer- 2 issues (1997)
Removing [showif] makes a big difference in speed (1997)
question: webmerchant connection (1997)
How to pass from a detail page to another? (1998)
[LOOKUP] (1997)
Trouble with Showif and Search (1998)
wee problem (2001)
TCPConnect to query for Domain expiration (2000)