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


_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to