How to remove repeating spaces

[Bill Vlahos]

I want to remove repeating spaces in a field. I can write a brute  
force method but before I do that I'd like to see if someone has  
already invented this wheel.

Basically all I want to do is reduce all multiple instances of spaces  
in a field to a single space. There could be double, triple, or more  
spaces together and I want to reduce them all to just one.

I can think of a repeating loop that replaces two spaces with one and  
just do it until there aren't any more or do a series of replaces four  
spaces with one, then three spaces with one, then two spaces with one  
but neither of these seem very elegant.

Bill Vlahos
_________________
InfoWallet (http://www.infowallet.com) helps me remember the important  
details of my life.