Hello,

Is there a way to either validate a field or write a script that removes spaces in FM7? I know the TrimAll feature would normally do this but it doesn't seem to be available in FM7.

Is there a way to do this?

Thanks.

Edited January 7, 200917 yr by Guest

One way of doing it is this:

http://www.briandunning.com/cf/904

--sd

Hi. Thanks for the reply. .

I'm afraid I couldn't get it working though, so I did a bit of searching and ended up doing the following:

Replace Field Contents [ Contact Data::Registration Number; Replace with calculation: Substitute ( Contact Data::Registration

Number ; " " ; "" ) ]

[ No dialog ]

If you don't wan't to mess with syntactical errors, could you have used:

http://www.myfmbutler.com/index.lasso?p=422

To transfer it, since the heavy (but necessary) commenting makes it easier to make a typo.

But Debi's method makes more comprehensive searches for all kinds of different non-letter or non-numbers, and convert it to a single space between each "word"

--sd

I'll keep it in mind. Thanks very much for your help.