Replace spaces for "and" 1

[vasilek]

Hello. I would like to replace all spaces in a string for " and ". For example: if user enters "Canon digital camera" in text field I would like to convert it to "Cannon and digital and camera",

Thanks a bunch!

 

[adam0101]

Like this:
mystring.replace(/ /g," and ");

but I hope you're not using JavaScript to write SQL. That's just too easy to hack.

Adam

Pedro offers you his protection

 

[BillyRayPreachersSon]

Why would you want to convert "Canon" to "Cannon"?

Dan


The answers you get are only as good as the information you give!

 

[vasilek]

BillyRayPreachersSon, I hoped it would make some booms

adam0101, this works, thanks. But now I realized: what if the user will mistakenly type "Canon digital camera", with two spaces. The result will be Canon and and digital and camera.

How this can be corrected?

Thanks.

 

[trollacious]

Then first convert all the multiple spaces (including possible triples or more) to single spaces:

while (mystring.indexOf('  ') > -1)
  {
  mystring.replace(/  /g," ");
  }
mystring.replace(/ /g," and ");

Lee

 

[tsuji]

Or this.
[tt] mystring.replace(/ +/g," and ");[/tt]