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 goessomething 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]][includesomefile][/GetChars][/Text] [HideIf [ThisChar]=] [AppendFile somenewfile][ThisChar][/AppendFile] [/HideIf] [ShowIf [ThisChar]=] [ShowIf [GetCharsstart=[math][index]+1[/math]&end=[math][index]+1[/math]][includesomefile][/GetChars]=] [AppendFile somenewfile][/AppendFile] [/ShowIf] [/ShowIf][/Loop]I offer no guarantees; I haven't even tried to run this, but in theory itshould do the job. If you're running 2.1, you could make it work by gettingrid of the text variable and just doing the [GetChars] in each of the 3 or4 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.5904o--------------- 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 goessomething 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]][includesomefile][/GetChars][/Text] [HideIf [ThisChar]=] [AppendFile somenewfile][ThisChar][/AppendFile] [/HideIf] [ShowIf [ThisChar]=] [ShowIf [GetCharsstart=[math][index]+1[/math]&end=[math][index]+1[/math]][includesomefile][/GetChars]=] [AppendFile somenewfile][/AppendFile] [/ShowIf] [/ShowIf][/Loop]I offer no guarantees; I haven't even tried to run this, but in theory itshould do the job. If you're running 2.1, you could make it work by gettingrid of the text variable and just doing the [getchars] in each of the 3 or4 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.5904o--------------- Dave MacLeay --+o----------- Digital Frontier --+o--------------- 802.253.8612 --+o--- dave@digitalfrontier.com --+ Dave MacLeay

DOWNLOAD WEBDNA NOW!

Re: Unexceling (was I need a smart quote...)

1999

Top Articles:

Related Readings: