hi,
how to trace whether therz 2 or more Spaces bt.words in a textbox?
Eg: hai hello (ie)2 spaces bt.hai and hello.
Printable View
hi,
how to trace whether therz 2 or more Spaces bt.words in a textbox?
Eg: hai hello (ie)2 spaces bt.hai and hello.
We're not talking via SMS here, you *can* say "between" rather than "bt"...you're just confusing matters if you use abbreviations like that :-P
Anyway, the best way to search for double spaces would be instr...instr(text1," ") would return the position in text1 where the double-space occurs.
If you want to *remove* double space and instead put single space, you can use replace in much the same way...text1 = replace(text1, " "," ")