How to remove repeating spaces

[Mark Schonewille]

Bill:

put replacetext(fld "Spaces","[ ]+"," ") into fld "Spaces"

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer

Download Strõm Flow Chart Software
http://flowproject.economy-x-talk.com

On 3 nov 2009, at 00:51, Bill Vlahos wrote:

> 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