remove spaces in a text field

[Salin]

There is a text field in my database that contains letters, numbers and spaces. Is there an easy way to remove all spaces from thousands of records in FM, Excel or other ways?

Thanks for any help!

-Sal

[mr_vodka]

TrimAll ( YourField; 1; 3).

If you want to do it for a set of records, then you can use Replace Field Contents [] with it. Just make sure that you backup prior because it is not undoable.

P.S. If you have an excel file, you can import it into FileMaker and do it in there if you wish.

Edited September 18, 2008 by Guest
added PS

[Salin]

John, thank you so much for your help! It works perfectly with a loop and that takes care of all found records.

-Sal