Finding two spaces in a string

[J. Muenchbourg]

I'm trying to do some len(string) , instr (string, arg) function combos
to detect a string that has at least two spaces, whereas I want to
eliminate that second space " " and concatenate the remainder of the
string into the second portion of the string. Any ideas, or web links
that can point me to a good source?

Thx
Muench

 

[Aaron Bertrand - MVP]

<%
str = " foo fooo oo o o o o bar "
do while instr(str, " ")>0
str = replace(str, " ", " ")
loop
response.write str
%>