Re: Replacing a Word

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24410
interpreted = N
texte = Anup Setty wrote:> Hi, > Can anyone help me with this problem? > I need to write the data from a textarea into the database, while > I am doing that, I want to replace a word with an html tag. > The text from the textarea has [image] and when I write in the > database I want it replaced by > > [image] = > > thanks > > anup >I worked out a little include that will do search and replace functions. call it as follows [include file=textreplace.incl&original=[yourtext]&from=[image]&to=]Hypothetically, if your textarea is [textarea], and you wished to append the information to a database calle database.db to a field called field, you would call it as follows:[append db=database.db]field=[include file=textreplace.incl&original=[textarea]&from=[image]&to=][/append]Please note a few things: First, due to the way the loop is set up, it will replace a maximum of 100 occurances. This is arbitrary and can be raised. Also, to use this, you will have to strip it of CRs (make it one long line), without a linefeed at the end. I'm posting it here with CRs so people can understand what's happening. Lastly, this routine probably strains the system somewhat. I reccomend you don't use it to replace all occurances of a word in a full book, for example. It is far from optimised.Here's the code snippet. Like I said, strip it of CRs and save it as textreplace.incl. -- [text show=f]x=[original][/text] [text show=f]to=[to][/text] [text show=f]from=[from][/text] [loop start=1&end=100&advance=1]
y=[text show=t]y=[middle startafter=[text]from[/text]&endbefore=][text]x[/text][/middle][/text] [showif [text]y[/text]![text]x[/text]] [text show=t]z=[middle startafter=&endbefore=[text]y[/text]][text]x[/text][/middle][/text][text show=t]a=[middle startafter=&endbefore=[text]from[/text]][text]z[/text][/middle][/text] [text show=t]x=[text]a[/text][text]to[/text][text]y[/text][/text] [/showif] [showif [text]y[/text]=[text]x[/text]] [break] [/showif] [/loop] [text]x[/text] --I hope you find this useful. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Replacing a Word (Anup Setty 1999)
  2. Re: Replacing a Word (Brian Boegershausen 1999)
  3. Replacing a Word (Anup Setty 1999)
  4. Re: Replacing a Word (Anup Setty 1999)
  5. Re: Replacing a Word (Rob Marquardt 1999)
  6. Re: Replacing a Word (Anup Setty 1999)
  7. Re: Replacing a Word (Derrick Puckett 1999)
  8. Re: Replacing a Word (Derrick Puckett 1999)
  9. Re: Replacing a Word (Jesse Williams Proudman 1999)
  10. Re: Replacing a Word (Derrick Puckett 1999)
  11. Replacing a Word (Anup Setty 1999)
Anup Setty wrote:> Hi, > Can anyone help me with this problem? > I need to write the data from a textarea into the database, while > I am doing that, I want to replace a word with an html tag. > The text from the textarea has [image] and when I write in the > database I want it replaced by > > [image] = > > thanks > > anup >I worked out a little include that will do search and replace functions. call it as follows [include file=textreplace.incl&original=[yourtext]&from=[image]&to=]Hypothetically, if your textarea is [textarea], and you wished to append the information to a database calle database.db to a field called field, you would call it as follows:[append db=database.db]field=[include file=textreplace.incl&original=[textarea]&from=[image]&to=][/append]Please note a few things: First, due to the way the loop is set up, it will replace a maximum of 100 occurances. This is arbitrary and can be raised. Also, to use this, you will have to strip it of CRs (make it one long line), without a linefeed at the end. I'm posting it here with CRs so people can understand what's happening. Lastly, this routine probably strains the system somewhat. I reccomend you don't use it to replace all occurances of a word in a full book, for example. It is far from optimised.Here's the code snippet. Like I said, strip it of CRs and save it as textreplace.incl. -- [text show=f]x=[original][/text] [text show=f]to=[to][/text] [text show=f]from=[from][/text] [loop start=1&end=100&advance=1]
y=[text show=t]y=[middle startafter=[text]from[/text]&endbefore=][text]x[/text][/middle][/text] [showif [text]y[/text]![text]x[/text]] [text show=t]z=[middle startafter=&endbefore=[text]y[/text]][text]x[/text][/middle][/text][text show=t]a=[middle startafter=&endbefore=[text]from[/text]][text]z[/text][/middle][/text] [text show=t]x=[text]a[/text][text]to[/text][text]y[/text][/text] [/showif] [showif [text]y[/text]=[text]x[/text]] [break] [/showif] [/loop] [text]x[/text] --I hope you find this useful. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Derrick Puckett

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:

Make sure I understand this??? (1997) setlineitem - price (2003) Cookies and webcat (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) using listfiles to build a database? more (2000) Moment of Thanks (1997) WebDNA 5 & iTools 7 (2003) Not really WebCat- (1997) empty shopping cart message (1997) WebMerchant docs (2000) RE: WebCat and image maps (1997) Apache 2.0 incompatible? (2005) WebCat2_Mac RETURNs in .db (1997) Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebCatalog NT (1996) Trouble with carts (2000) Site / Database Structure (2002) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) using showpage and showcart commands (1996)